Statistics
Statistics[=(options)]
Specifies the type of statistics you want to collect for the
items specified with the Tables, System_Relations, and Indexes
qualifiers. If you specify the Statistics qualifier without
an options list, all statistics are collected for the items
specified.
If you specify the Statistics qualifier with an options list,
Oracle RMU collects types of statistics described in the
following list. If you specify more than one option, separate the
options with commas and enclose the options within parenthesis.
The Statistics qualifier options are:
o Cardinality
Collects the table cardinality for the tables specified with
the Tables and System_Relations qualifiers and the index and
index prefix cardinalities for the indexes specified with the
Indexes qualifier. Because cardinalities are automatically
maintained by Oracle Rdb, it is usually not necessary
to collect cardinality statistics using the RMU Collect
Optimizer_Statistics command unless you have previously
explicitly disabled cardinality updates.
o Workload
Collects the Column Group, Duplicity Factor, and Null Factor
workload statistics for the tables specified with the Tables
and System_Relations qualifiers.
o Storage
Collects the following statistics:
- Table Row Clustering Factor for the tables specified with
the Tables qualifier
- Index Key Clustering Factor, the Index Data Clustering
Factor, and the Average Index Depth for the indexes
specified with the Indexes qualifier
See System Tables Used to Store Optimizer Statistics in the
Usage_Notes entry for this command for information on the
columns and tables used in the system relations to store these
statistics.