OWNER

CHAR(32)

Name of the owner of the index

TABLENAME

CHAR(32)

Name of the table

INDEXNAME

CHAR(32)

Index name

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

DISABLED

CHAR(3)

Index not active for search operations (YES | NO)

COMMENT

LONG

Comment on the index