VMS Help  —  RMU72  Collect Optimizer Statistics, Command Qualifiers, Indexes
    Indexes
    Indexes[=(index-list)]
    Noindex

    Specifies the index or indexes for which statistics are to be
    collected. If you do not specify an index-list, statistics for
    all indexes defined for the tables specified with the Tables
    qualifier are collected. If you specify an index-list, statistics
    are collected only for the named indexes. If you specify
    the Noindex qualifier, statistics for the index cardinality,
    average index depth, index key clustering factor, and index data
    clustering factor are not collected.

    Specify the Notable qualifier if you do not want statistics
    collected for tables. (Remember, the Tables qualifier without
    a table-list is the default.)

    The default is the Indexes qualifier without an index-list.
Close Help