SCHEMANAME

CHAR(32)

Name of the schema of the index

OWNER

CHAR(32)

Name of the owner of the index

TABLENAME

CHAR(32)

Name of the table

INDEXNAME

CHAR(32)

Name of the index

FILEID

CHAR(8) BYTE

ID of the index file

TYPE

CHAR(6)

Index type (UNIQUE | NULL)

CREATEDATE

DATE(10)

Creation date of the index

CREATETIME

TIME(8)

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)

Index status (OK | DELETED | BAD | READ ONLY | UNKNOWN)

DISABLED

CHAR(3)

Index not active for search operations (YES | NO)

COMMENT

LONG

Comment on the index