Object documentationTABLESTORAGEDETAILS Locate this document in the navigation structure

 

The system table SYSINFO.TABLESTORAGEDETAILS contains information about the structure and size of tables.

Structure

TABLESTORAGEDETAILS

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

More Information

FILES

INDEXSTORAGEDETAILS

Concepts of the Database System, Logical Access Structures