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.