The system table DOMAIN.INDEXES contains all the indexes for which the current user has privileges.
SCHEMANAME |
CHAR(32) |
Name of the table schema |
OWNER |
CHAR(32) |
Name of the owner of the table |
TABLENAME |
CHAR(32) |
Name of the table |
INDEXNAME |
CHAR(32) |
Name of the index |
FILEID |
CHAR(8) BYTE |
Identification of the index file |
TYPE |
CHAR(6) |
Index type (UNIQUE | NULL) |
CREATEDATE |
DATE |
Creation date of the index |
CREATETIME |
TIME |
Creation time of the index |
INDEX_USED |
FIXED(10) |
Frequency of use in search operations |
INDEXUSEDRESETDATE |
DATE |
Date on which ALTER INDEX INIT USAGE was last executed |
INDEXUSEDRESETTIME |
TIME |
Time at which ALTER INDEX INIT USAGE was last executed |
FILESTATE |
CHAR(20) |
Status of the index (OK | BAD | MISSING) |
DISABLED |
CHAR(3) |
Index not active for search operations (YES | NO) |
COMMENT |
CLOB |
Comment on the index |
If the INDEXES system table is called by the database system administrator, information from all database users indexes is displayed.