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 |
AVGUNPACKEDROWLENGTH |
FIXED(5) |
Average length of the unpacked table rows (For tables with one of the PACKED attributes this column returns the average size of the table's rows after unpacking. For tables that are not packed, this value is the same as in column AVGROWLENGTH.) |
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 |
SEPARATORCOUNT |
FIXED(10) |
Number of separators |
Concepts of the Database System, Logical Access Structures