INDEXSIZE

Definition

The system table 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

See also:

FILES