USER_INDEXES v17
The USER_INDEXES
view provides information about all indexes on tables that are owned by the current user.
Name | Type | Description |
---|---|---|
schema_name | TEXT | Name of the schema in which the index belongs. |
index_name | TEXT | Name of the index. |
index_type | TEXT | Included only for compatibility. The index type is always BTREE . |
table_owner | TEXT | User name of the owner of the indexed table. |
table_name | TEXT | Name of the indexed table. |
table_type | TEXT | Included only for compatibility. Always set to TABLE . |
uniqueness | TEXT | Indicates if the index is UNIQUE or NONUNIQUE . |
compression | CHARACTER(1) | Included only for compatibility. Always set to N (not compressed). |
tablespace_name | TEXT | Name of the tablespace in which the table resides if other than the default tablespace. |
degree | CHARACTER VARYING(10) | Number of threads per instance to scan the index. |
logging | TEXT | Included only for compatibility. Always set to LOGGING . |
status | TEXT | Whether or not the state of the object is valid. (VALID or INVALID ). |
partitioned | CHARACTER(3) | Included only for compatibility. Always set to NO . |
temporary | CHARACTER(1) | Included only for compatibility. Always set to N . |
secondary | CHARACTER(1) | Included only for compatibility. Always set to N . |
join_index | CHARACTER(3) | Included only for compatibility. Always set to NO . |
dropped | CHARACTER(3) | Included only for compatibility. Always set to NO . |