Database Statistics

---

The SQL statistics statements collect statistical information about table and index data in the database and store this information in the data dictionary.

The information is used by the SQL compiler in optimizing access paths for SQL queries.

The statistical information includes:

• the total number of rows in each base table
• the number of distinct values in each column of a table
• the number of non-NULL values in each column of a table
• the lowest and highest values in each column of a table

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se