This system table describes all indices on tables to which the current user has access. All users have access to the table.
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|