The system table SYSINFO.TABLESTORAGEDETAILS contains information about the structure and size of tables.
SCHEMANAME |
CHAR(32) |
Name of the schema |
TABLENAME |
CHAR(32) |
Name of the table |
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 |
AVGROWCOUNTPERLEAF |
FIXED(5) |
Average number of table rows per page |
MINROWCOUNTPERLEAF |
FIXED(5) |
Minimum number of table rows on a page |
MAXROWCOUNTPERLEAF |
FIXED(5) |
Maximum number of table rows on a page |
AVGROWLENGTH |
FIXED(5) |
Average length of the table rows |
MINROWLENGTH |
FIXED(5) |
Length of the shortest table row |
MAXROWLENGTH |
FIXED(5) |
Length of the longest table row |
DEFINEDLOBCOLUMNCOUNT |
FIXED(10) |
Number of LOB column values that are not NULL |
AVGLOBCOLUMNLENGTH |
FIXED(10) |
Average length of all potentially existing LOB column values |
MINLOBCOLUMNLENGTH |
FIXED(10) |
Minimum length of an existing LOB column value |
MAXLOBCOLUMNLENGTH |
FIXED(10) |
Maximum length of an existing LOB column value |
CLUSTERCOUNT |
FIXED(10) |
Number of pages stored in clusters |
RECORDEXTENSIONPAGECOUNT |
FIXED(10) |
Number of data pages with records that are longer than 8 KB |