This system table describes all indices on tables. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
The indices are created and managed automatically by the system. Hence, the purpose of this table is mainly for transparency.
|INDEX_SCHEMA||Schema of the index|
|INDEX_TABLE||Table of the index|
|INDEX_OWNER||Owner of the index|
|INDEX_OBJECT_ID||ID of the index|
|IS_GEOMETRY||States whether this is a geospatial index|
|MEM_OBJECT_SIZE||Index size in bytes (at last COMMIT)|
|CREATED||Timestamp of when the index was created|
|LAST_COMMIT||Last time the object was changed in the DB|
|REMARKS||Additional information about the index|