USER_INDEXES v13

The USER_INDEXES view provides information about all indexes on tables that are owned by the current user.

NameTypeDescription
schema_nameTEXTName of the schema in which the index belongs.
index_nameTEXTThe name of the index.
index_typeTEXTIncluded for compatibility only. The index type is always BTREE.
table_ownerTEXTUser name of the owner of the indexed table.
table_nameTEXTThe name of the indexed table.
table_typeTEXTIncluded for compatibility only. Always set to TABLE.
uniquenessTEXTIndicates if the index is UNIQUE or NONUNIQUE.
compressionCHARACTER(1)Included for compatibility only. 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 for compatibility only. Always set to LOGGING.
statusTEXTWhether or not the state of the object is valid. (VALID or INVALID).
partitionedCHARACTER(3)Included for compatibility only. Always set to NO.
temporaryCHARACTER(1)Included for compatibility only. Always set to N.
secondaryCHARACTER(1)Included for compatibility only. Always set to N.
join_indexCHARACTER(3)Included for compatibility only. Always set to NO.
droppedCHARACTER(3)Included for compatibility only. Always set to NO.