## Statistical Information

The statistical information includes:

- the total number of rows in each base table, stored in the column TABLE_CARD in the table's row in SYSTEM.TABLES
- the number of distinct values in each column of a table, stored in the column COLUMN_CARD in the column's row in SYSTEM.COLUMNS
- the number of non-NULL values in each column of a table, stored in the column COLUMN_CARD_NONULL in the column's row in SYSTEM.COLUMNS
- the lowest and highest values in each column of a table, stored in the columns COLUMN_LOW_VALUE and COLUMN_HIGH_VALUE in the column's row in SYSTEM.COLUMNS

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |