TABLESTATISTICS 
The statistics system table <DATABASE_SYSTEM_ADMINISTRATOR>.TABLESTATISTICS contains information about the structure and sizes of base tables.
Structure
SCHEMANAME |
CHAR(32) |
Name of the table schema |
OWNER |
CHAR(32) |
Name of the owner of the table |
TABLENAME |
CHAR(32) |
Name of the table |
DESCRIPTION |
CHAR(40) |
Description of how to interpret the following columns (see DESCRIPTION Column table) |
CHAR_VALUE |
CHAR(12) |
Alphanumerical value |
NUMERIC_VALUE |
FIXED(10) |
Numerical value |
Value |
Explanation |
|---|---|
Root pno |
NUMERIC_VALUE contains the page number of the B* tree root |
FILETYPE |
CHAR_VALUE contains the B* tree type |
Used pages |
NUMERIC_VALUE contains the number of pages used by the table |
Index pages |
NUMERIC_VALUE contains the number of pages used by the table in the B* tree index |
Leaf pages |
NUMERIC_VALUE contains the number of leaf pages used by the table |
Index levels |
NUMERIC_VALUE contains the number of B* tree index levels |
Space used in all pages(%) |
NUMERIC_VALUE contains the percentage of the B* tree root pages used |
Space used in root page(%) |
NUMERIC_VALUE contains the percentage of the B* tree root pages used |
Space used in index pages(%) |
NUMERIC_VALUE contains the percentage of the B* tree index pages used |
Space used in index pages(%) min |
NUMERIC_VALUE contains the minimum percentage of the B* tree index pages used |
Space used in index pages(%) max |
NUMERIC_VALUE contains the maximum percentage of the B* tree index pages used |
Space used in leaf pages(%) |
NUMERIC_VALUE contains the maximum percentage of the B* tree leaf pages used |
Space used in leaf pages(%) min |
NUMERIC_VALUE contains the minimum percentage of the B* tree leaf pages used |
Space used in leaf pages(%) max |
NUMERIC_VALUE contains the maximum percentage of the B* tree leaf pages used |
Rows |
NUMERIC_VALUE contains the number of rows in the table |
Avg rows per page |
NUMERIC_VALUE contains the average number of rows per page |
Min rows per page |
NUMERIC_VALUE contains the minimum number of rows per page |
Max rows per page |
NUMERIC_VALUE contains the maximum number of rows per page |
Avg row length |
NUMERIC_VALUE contains the average length of rows |
Min row length |
NUMERIC_VALUE contains the minimum length of rows |
Max row length |
NUMERIC_VALUE contains the maximum length of rows |
Avg key length |
NUMERIC_VALUE contains the average length of keys |
Min key length |
NUMERIC_VALUE contains the minimum length of keys |
Max key length |
NUMERIC_VALUE contains the maximum key length |
Avg separator length |
NUMERIC_VALUE contains the average length of the separator |
Min separator length |
NUMERIC_VALUE contains the minimum length of the separator |
Max separator length |
NUMERIC_VALUE contains the maximum length of the separator |
Defined LOB columns |
NUMERIC_VALUE contains the number of defined LOB columns |
Avg LOB column length |
NUMERIC_VALUE contains the average length of LOB columns |
Min LOB column length |
NUMERIC_VALUE contains the minimum length of LOB columns |
Max LOB column length |
NUMERIC_VALUE contains the maximum length of LOB columns |
LOB column pages |
NUMERIC_VALUE contains the number of pages of all the LOB columns in the table |
Avg pages per LOB column |
NUMERIC_VALUE contains the average number of pages in the table per LOB column |
Min pages per LOB column |
NUMERIC_VALUE contains the smallest LOB column in the table in pages |
Max pages per LOB column |
NUMERIC_VALUE contains the largest LOB column in the table in pages |
Rows with trailing blanks |
NUMERIC_VALUE contains the number of rows in the table where at least one column value has trailing blanks |
Record extension pages |
NUMERIC_VALUE contains the number of pages that are filled with particularly long table rows |
More Information
Concepts of the Database System, Logical Access Structures