The system table SYSINFO.INDEXSTORAGEDETAILS contains information about the structure and size of indexes.
SCHEMANAME |
CHAR(32) |
Name of the schema |
TABLENAME |
CHAR(32) |
Name of the table |
INDEXNAME |
CHAR(32) |
Name of the index |
TREELEVELCOUNT |
FIXED(3) |
Number of B* tree index levels |
AVGSEPARATORLENGTH |
FIXED(4) |
Average separator length |
MINSEPARATORLENGTH |
FIXED(4) |
Minimum separator length |
MAXSEPARATORLENGTH |
FIXED(4) |
Maximum separator length |
AVGUSEDSIZEPERCENTAGEINLEAVES |
FIXED(3) |
Average fill level of the pages that contain data |
MINUSEDSIZEPERCENTAGEINLEAVES |
FIXED(3) |
Minimum fill level of a page that contains data |
MAXUSEDSIZEPERCENTAGEINLEAVES |
FIXED(3) |
Maximum fill level of a page that contains data |
AVGSECONDARYKEYLENGTH |
FIXED(4) |
Average length of the secondary key values |
MINSECONDARYKEYLENGTH |
FIXED(4) |
Minimum length of a secondary key value |
MAXSECONDARYKEYLENGTH |
FIXED(4) |
Maximum length of a secondary key value |
AVGROWCOUNTPERSECONDARYKEY |
FIXED(10) |
Average number of table rows per secondary key |
MINROWCOUNTPERSECONDARYKEY |
FIXED(10) |
Minimum number of table rows per secondary key |
MAXROWCOUNTPERSECONDARYKEY |
FIXED(10) |
Maximum number of table rows per secondary key |
CLUSTERCOUNT |
FIXED(10) |
Number of pages stored in clusters |