Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  CREATE  DATABASE  Arguments  WORKLOAD_COLLECTION
    Syntax options:

    WORKLOAD COLLECTION IS ENABLED | WORKLOAD COLLECTION IS DISABLED

    Specifies whether or not the optimizer records workload
    information in the system table RDB$WORKLOAD. The WORKLOAD
    COLLECTION IS ENABLED clause creates this system table if it
    does not exist. If you later disable workload collection, the
    RDB$WORKLOAD system table is not deleted.

    A workload profile is a description of the interesting table
    and column references used by queries in a database workload.
    When workload collection is enabled, the optimizer collects
    and records these references in the RDB$WORKLOAD system table.
    This work load is then processed by the RMU Analyze Statistics
    command which records useful statistics about the work load.
    These workload statistics are used by the optimizer at run time
    to deliver more accurate access strategies.

    Workload collection is disabled by default.
Close Help