TABLESTATISTICS
This
statistical system table contains information about structure and size of Basis tables.TABLESTATISTICS
|
OWNER |
CHAR ( 32) |
Table owner |
|
TABLENAME |
CHAR ( 32) |
Table name |
|
DESCRIPTION |
CHAR ( 40) |
Description of how to interpret the following columns (see Column DESCRIPTION table) |
|
CHAR_VALUE |
CHAR ( 12) |
Alphanumeric value |
|
NUMERIC_VALUE |
FIXED (10) |
Numeric value |
DESCRIPTION column
|
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 page used |
|
Space used in root page(%) |
NUMERIC_VALUE contains the percentage of the B* tree root page 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 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 table rows |
|
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 |
|
Min 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 length of keys |
|
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 LONG columns |
NUMERIC_VALUE contains the number of defined columns with the data type LONG |
|
Avg LONG column length |
NUMERIC_VALUE contains the average length of LONG columns |
|
Min LONG column length |
NUMERIC_VALUE contains the minimum length of LONG columns |
|
Max LONG column length |
NUMERIC_VALUE contains the maximum length of LONG columns |
|
LONG column pages |
NUMERIC_VALUE contains the number of pages of all the LONG columns in the table |
|
Avg pages per LONG column |
NUMERIC_VALUE contains the average number of pages in the table per LONG column |
|
Min pages per LONG column |
NUMERIC_VALUE contains the smallest LONG column in the table in pages |
|
Max pages per LONG column |
NUMERIC_VALUE contains the largest LONG column in the table in pages |