Oracle Database Discussions

For one of our schemas, the INDEX count is 1435 as per user_objects view. But the USER_INDEXES confirm that there are actually 1446 indexes. So, where does this difference of 11 come from in user_objects view ?


DB version: 11.2.0.2
Platform : RHEL 5.4

SQL> select count(*) from user_indexes;

  COUNT(*)
----------
      1446




SQL> select object_type, count(*) from user_objects group by object_type order by count(*) desc;

OBJECT_TYPE           COUNT(*)
------------------- ----------
INDEX                     1435      -----------> Here index count is 11 short than the actual count. This is wrong
TABLE                     1037
VIEW                        29
TRIGGER                     11
.
.
.
.

Has this got anything to do with INVISIBLE indexes ? But I don't see any INVISIBLE indexes in this schema.

SQL> select distinct VISIBILITY from USER_INDEXES;

VISIBILIT
---------
VISIBLE


SQL > show parameter invisible

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
optimizer_use_invisible_indexes      boolean     FALSE

Any idea about the difference in these counts ?

Edited by: GarryB on Nov 23, 2012 1:07 AM