DBA_INDEXES v15

The DBA_INDEXES view provides information about all indexes in the database.

NameTypeDescription
ownerTEXTUser name of the index owner.
schema_nameTEXTName of the schema in which the index resides.
index_nameTEXTName of the index.
index_typeTEXTThe index type is always BTREE. Included only for compatibility.
table_ownerTEXTUser name of the owner of the indexed table.
table_nameTEXTName of the indexed table.
table_typeTEXTIncluded only for compatibility. Always set to TABLE.
uniquenessTEXTIndicates if the index is UNIQUE or NONUNIQUE.
compressionCHARACTER(1)Included only for compatibility. Always set to N (not compressed).
tablespace_nameTEXTName of the tablespace in which the table resides if other than the default tablespace.
degreeCHARACTER VARYING(10)Number of threads per instance to scan the index.
loggingTEXTIncluded only for compatibility. Always set to LOGGING.
statusTEXTWhether or not the state of the object is valid (VALID or INVALID).
partitionedCHARACTER(3)Indicates that the index is partitioned. Always set to NO.
temporaryCHARACTER(1)Indicates that an index is on a temporary table. Always set to N.
secondaryCHARACTER(1)Included only for compatibility. Always set to N.
join_indexCHARACTER(3)Included only for compatibility. Always set to NO.
droppedCHARACTER(3)Included only for compatibility. Always set to NO.