HELPLIB.HLB  —  RMU72  Delete Optimizer Statistics, Command Qualifiers, Tables
    Tables=(table-list)

    Specifies the table or tables for which column group entries are
    to be deleted, as follows:

    o  If you specify the Tables=(table-list) qualifier, but do
       not specify the Column_Group qualifier, then all column
       group entries for the listed tables are deleted from the
       RDB$WORKLOAD system table.

    o  If you specify the Tables=(table-list) qualifier, and you
       specify the Column_Group=(column-list) qualifier, then the
       workload statistics entries for the specified tables that
       have exactly the specified column group are deleted from the
       RDB$WORKLOAD system table.

    o  If you use an asterisk (*) with the Tables qualifier
       (Tables=*), all tables registered in the RDB$WORKLOAD table
       are deleted. This allows the RDB$WORKLOAD table to be purged.

    If you issue an RMU Collect Optimizer_Statistics command after
    you have deleted a workload column group from the RDB$WORKLOAD
    system table, those statistics are no longer collected.

    The Tables=(table-list) qualifier is a required qualifier; you
    cannot issue an RMU Delete Optimizer_Statistics command without
    the Tables=(table-list) qualifier.
Close Help