Show TOC

Object documentationINDEXES Locate this document in the navigation structure

 

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

Structure

INDEXES

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

FUNCTIONSCHEMANAME

CHAR(32)

Name of the schema of the database function used for the function index

FUNCTIONNAME

CHAR(32)

Name of the database function used for the function index

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.

More Information

Evaluating System Tables, INDEXES

SQL Reference Manual, Index Name (index_name)