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 the database catalog.
The SQL Optimizer uses this information to define the best strategy for executing
an SQL statement. The MONITOR
statement can
be used to initialize counters for monitoring the database.