EXA_USER_INDICES
This system table describes all indices on tables owned by the current user. 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.
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 |