INDEXSTORAGEDETAILS
The system table SYSINFO.INDEXSTORAGEDETAILS contains information about the structure and size of indexes.
|
SCHEMANAME |
CHAR(32) |
Name of the schema |
|
TABLE NAME |
CHAR(32) |
Name of the table |
|
INDEX NAME |
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 |
|
AVGROWCOUNTPER SECONDARYKEY |
FIXED(10) |
Average number of table rows per secondary key |
|
MINROWCOUNTPER SECONDARYKEY |
FIXED(10) |
Minimum number of table rows per secondary key |
|
MAXROWCOUNTPER SECONDARYKEY |
FIXED(10) |
Maximum number of table rows per secondary key |
|
CLUSTERCOUNT |
FIXED(10) |
Number of pages stored in clusters |