DBA_INDEXES

In this view are listed all the indexes in the database. There are the corresponding ALL_INDEXES and USER_INDEXES, showing, respectively, the indexes which the current user can access and the indexes the current user owns.

Fields

The most relevant view fields are as follows:

  • OWNER: The owner of the index
  • INDEX_NAME: The name of the index
  • TABLE_OWNER: The owner of the table on which the index is built
  • TABLE_NAME: The name of the table on which the index is built
  • TABLESPACE_NAME: The name of the tablespace in which the index is stored
  • STATUS: This can be VALID or UNUSABLE
  • INDEX_TYPE: The type of the index; can be NORMAL, BITMAP, FUNCTION-BASED NORMAL, FUNCTION-BASED BITMAP, or DOMAIN
  • TABLE_TYPE: The type of the indexed object (TABLE or CLUSTER ...

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial