INDEXES

Definition

The system table INDEXES contains all the indexes for which the current user has privileges.

Structure

INDEXES

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

If the INDEXES system table is called by the database system administrator, information on all database users’ indexes is displayed.

See also:

Evaluating System Tables, INDEXES

SQL Reference Manual, Index Name (index_name)