HELPLIB.HLB  —  RMU72  Show  Optimizer Statistics, Command Qualifiers, Threshold
    Threshold=options
    Nothreshold

    The Threshold qualifier can only be used in conjunction with
    the Full qualifier. If this qualifier is used, an additional
    Threshold column is added to the display. You can specify the
    following options with the Threshold qualifier:

    o  Percent=n

       The value for Percent=n can be an integer value from 0 to 99.
       The default value for n is 0. If Percent=n is not specified
       or if a percent value of 0 is specified, any percentage
       difference from the actual cardinality value is flagged as
       "*over*" in the output column. If a percent value of 1 to
       99 is specified, any percentage difference from the actual
       cardinality value that is greater than the percent value
       specified is flagged as "*over*" in the output column. In the
       report, the Threshold column displays those cardinality values
       in which the percent difference exceeds the specified value.
       If the threshold is not exceeded, the column is blank. If the
       threshold is exceeded, the column shows the string "*over*".

    o  Log={All|Over_Threshold}

       If Log is not specified or if Log=All is specified, all
       cardinality values are displayed. If Log=Over_Threshold is
       specified, only cardinality values that exceed the threshold
       percentage are flagged as "*over*" in the output column.
Close Help