Object documentationINDEXSIZE Locate this document in the navigation structure

 

The system table SYSINFO.INDEXSIZE contains size information about indexes.

Structure

INDEXSIZE

SCHEMANAME

CHAR(32)

Name of the schema

TABLENAME

CHAR(32)

Name of the table

INDEXNAME

CHAR(32)

Name of the index

USEDSIZE

FIXED(20)

Space used by the index (KB)

SECONDARYKEYCOUNT

FIXED(20)

Number of different secondary key values

More Information

FILES