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