The ALL_INDEXES view provides the information about the indexes on tables that may be accessed by the current user.

Parameter Type Description
owner TEXT The username of the owner to which the index belongs.
schema_name TEXT The name of the schema to which the index belongs.
index_name TEXT The name of the index.
index_type TEXT The index type is BTREE. This parameter is supported for compatibility only.
table_owner TEXT The username of the owner of the 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 if the index is UNIQUE or NONUNIQUE.
compression CHARACTER(1) The value is N (not compressed). This parameter is supported for compatibility only.
tablespace_name TEXT The name of the tablespace where the table is located if this tablespace is not the default tablespace.
logging TEXT The value is LOGGING. This parameter is supported for compatibility only.
status TEXT This parameter is supported for compatibility only. The value is VALID.
partitioned CHARACTER(3) Indicates that the index is partitioned. The value is NO.
temporary CHARACTER(1) Indicates that an index is on a temporary table. 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.