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