HELPLIB.HLB  —  RMU72  Collect Optimizer Statistics, Command Qualifiers, Tables
    Tables
    Tables[=(table-list)]
    Notables

    Specifies the table or tables for which statistics are to be
    collected. If you specify a table-list, statistics for those
    tables and their associated indexes are collected. If you do
    not specify a table-list, statistics for all tables and their
    associated indexes in the database are collected. If you do
    not specify the Table qualifier, statistics for all tables are
    collected. If you specify the Notables qualifier, statistics for
    for the table cardinality, table row clustering factor, column
    group duplicity factor, and column group null factor are not
    collected.

    Specify the Noindex qualifier if you do not want statistics
    collected for indexes.

    The Tables qualifier without a table-list is the default.
Close Help