Statistics

The UPDATE STATISTICS statement defines the storage requirements of tables and indexes as well as the value distribution of columns, and stores this information in statistics system tables. The SQL Optimizer uses this information to determine the best strategy for executing an SQL statement.

The MONITOR statement can be used to initialize counters for monitoring the database.

SQL statements for statistics management

UPDATE STATISTICS Statement

MONITOR Statement

See also:

Definitions of the System Tables