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