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