INDEXSIZE
Definition
The system table SYSINFO.INDEXSIZE contains size information about indexes.
Structure
|
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