HELPLIB.HLB  —  RMU72  Delete Optimizer Statistics, Description
    When you enable and collect workload statistics, the system
    table, RDB$WORKLOAD, is created and populated. (See Collect_
    Optimizer_Statistics for details.) If you are knowledgeable
    about the data in your database, or if workload statistics were
    gathered for queries that are no longer in use, you might decide
    that you no longer want Oracle RMU to collect statistics for
    particular column groups. The RMU Delete Optimizer_Statistics
    gives you the ability to selectively delete records for column
    groups in the RDB$WORKLOAD system table.

    When you use the RMU Delete Optimizer_Statistics command, both
    the optimizer statistics themselves and the reference to the
    column duplicity factor and the null factor are deleted from the
    RDB$WORKLOAD system table.

    If you issue an RMU Collect Optimizer_Statistics command after
    having issued an RMU Delete Optimizer_Statistics command,
    statistics for the specified column group are not collected.
Close Help