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

Parameter Type Description
schema_name TEXT The name of the schema to which an index belongs.
index_name TEXT The name of the index.
index_type TEXT This parameter is supported for compatibility only. The index type is BTREE.
table_owner TEXT The username of the owner of an indexed table.
table_name TEXT The name of the indexed table.
table_type TEXT This parameter is supported for compatibility only. The value is TABLE.
uniqueness TEXT Indicates whether the index is UNIQUE or NONUNIQUE.
compression CHARACTER(1) This parameter is supported for compatibility only. The value is N (not compressed).
tablespace_name TEXT The name of the tablespace where the table is located if this tablespace is not the default tablespace.
logging TEXT This parameter is supported for compatibility only. The value is LOGGING.
status TEXT Indicates whether the state of the object is valid. Valid values: VALID and INVALID.
partitioned CHARACTER(3) This parameter is supported for compatibility only. The value is NO.
temporary CHARACTER(1) This parameter is supported for compatibility only. The value is N.
secondary CHARACTER(1) This parameter is supported for compatibility only. The value is N.
join_index CHARACTER(3) This parameter is supported for compatibility only. The value is NO.
dropped CHARACTER(3) This parameter is supported for compatibility only. The value is NO.