Entering content frame

Object documentation TABLESTATISTICS Locate the document in the library structure

Definition

The statistics system table TABLESTATISTICS contains information about the structure and sizes of base tables.

Structure

TABLESTATISTICS

SCHEMANAME

CHAR(32)

Name of the schema of the table

OWNER

CHAR(32)

Name of the owner of the table

TABLENAME

CHAR(32)

Table name

DESCRIPTION

CHAR(40)

Description of how to interpret the following columns (see DESCRIPTION Column 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

File type

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 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

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 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

See also:

FILES

Concepts of the Database System, Logical Access Structures

 

Leaving content frame