1  –  Column Group

    Column_Group=(column-list)

    Specifies a list of columns that comprise a column group. You
    must use the Tables qualifier to specify the table or tables with
    which the columns are associated.

    The Column_Group=(column-list) qualifier is a required qualifier.

2  –  Duplicity Factor

    Duplicity_Factor=(floating-number)

    Specifies the value to be inserted in the RDB$DUPLICITY_FACTOR
    column in the RDB$WORKLOAD table for the specified column group
    and table (or tables). The minimum value is 1.0 and the maximum
    value is the cardinality of the specified table. The default is
    the Duplicity_Factor=(1.0) qualifier.

3  –  Log

    Log
    Log=file-spec
    Nolog

    Specifies how the statistics inserted into the RDB$WORKLOAD
    system table are to be logged. Specify the Log qualifier to have
    the information displayed to SYS$OUTPUT. Specify the Log=file-
    spec qualifier to have the information written to a file. Specify
    the Nolog qualifier to prevent display of the information. If you
    do not specify any of variation of the Log qualifier, the default
    is the current setting of the DCL verify switch. (The DCL SET
    VERIFY command controls the DCL verify switch.)

4  –  Null Factor

    Null_Factor=floating-number

    Specifies the value to be inserted in the RDB$NULL_FACTOR column
    in the RDB$WORKLOAD table for the specified column group and
    table (or tables). The minimum value is 0.0 and the maximum value
    is 1.0. The default is the Null_Factor=(0.0) qualifier.

5  –  Tables

    Table

    Tables=(table-list)

    Specifies the table or tables for which column group entries are
    to be inserted.

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

    The Tables=(table-list) qualifier is a required qualifier.