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. |