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