Background documentationStatistics Locate this document in the navigation structure

 

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.

Structure

SQL Statements for Statistics Management

UPDATE STATISTICS Statement

MONITOR Statement