VMS Help  —  RMU72  Show  Optimizer Statistics, Command Qualifiers, Statistics
    Statistics

    Statistics[=(options)]

    Specifies the type of statistics you want to display 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 displayed for the items
    specified.

    If you specify the Statistics qualifier with an options list,
    Oracle RMU displays the 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 parentheses.

    The Statistics qualifier options are:

    o  Cardinality

       Displays 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.

    o  Workload

       Displays the Column Group, Duplicity Factor, and Null Factor
       workload statistics for the tables specified with the Tables
       and System_Relations qualifiers.

    o  Storage

       Displays 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.
Close Help