This system table describes all indexes on tables. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
The indexes are created and managed automatically by the system. Hence, the purpose of this table is mainly for transparency. For more information, see Indexes.
| Column Name | Description |
|---|---|
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 |
INDEX_TYPE
|
Index type |
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 |
