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)

• UNIQUENESS: Whether the index is UNIQUE or NONUNIQUE

• COMPRESSION: If the index is compressed then the value is ENABLED, else DISABLED

• PREFIX_LENGTH: The number of columns in the compressed prefix of the key

• LEAF_BLOCKS: The number of leaf blocks in the index