Object documentationINDEXSTORAGEDETAILS Locate this document in the navigation structure

 

The system table SYSINFO.INDEXSTORAGEDETAILS contains information about the structure and size of indexes.

Structure

INDEXSTORAGEDETAILS

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

More Information

FILES

Concepts of the Database System, Logical Access Structures