Statistics

Use

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

Table 1: SQL Statements for Statistics Management
UPDATE STATISTICS Statement	MONITOR Statement

More Information

Database Administration, SQL Optimizer

Definitions of the System Tables

SQL Statements: Overview

SQL Reference Manual