VMS Help  —  RMU72  Collect Optimizer Statistics, Command Qualifiers, Statistics
    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.
Close Help