Neoview Workload Management Services Guide (R2.5)

rule-specifier-list
specifies one or more comma-separated comp-expression. WMS tests each
comp-expression in the rule-specifier-list in the order in which you specify them.
A rule-specifier-list can contain a maximum of 15 comp-expression.
comp-expression
specifies one of these compilation rule expressions:
An expression comparing the estimated memory for the
query with a numeric value that you specify. The value
of the second operand, numeric-value, is in kilobytes.
EST_TOTAL_MEMORY rule-operator
numeric-value
An expression comparing the estimated time to execute
the query with a numeric value that you specify. The
value of the second operand, numeric-value, is in
minutes.
EST_TOTAL_TIME rule-operator
numeric-value
An expression comparing the estimated total number of
rows that the query will return with a numeric value that
you specify.
EST_CARDINALITY rule-operator
numeric-value
An expression comparing the estimated number of rows
that will be accessed by all the scan, insert, update, and
delete operators in the query plan with a numeric value
that you specify.
EST_ACCESSED_ROWS rule-operator
numeric-value
An expression comparing the estimated number of rows
that will be accessed by scan and insert operators in the
query plan with a numeric value that you specify.
EST_USED_ROWS rule-operator
numeric-value
An expression comparing the number of joins in the
query plan with a numeric value that you specify.
NUM_JOINS rule-operator numeric-value
An expression comparing the maximum number of rows
that will be accessed during a full scan of a table, if a full
scan is enabled, with a numeric value that you specify.
SCAN_SIZE rule-operator numeric-value
An expression that evaluates to true if statistics are
missing for a single-column group. Otherwise, the
expression evaluates to false.
UPDATE_STATS_WARNING
An expression that evaluates to true if the query has a
cross join (that is, a join without a predicate). Otherwise,
the expression evaluates to false.
CROSS_PRODUCT
rule-operator
specifies the operator to use when comparing the first operand of the comp-expression
to the second operand. The rule-operator can be:
= | >= | > | < | <= | < >
numeric-value
specifies a number in the range of 0 to 9223372036854775807.
warn-level
specifies the warning level. warn-level can be one of these values:
• WARN-HIGH
• WARN-MEDIUM
• WARN-LOW
• NO-WARN
If you do not specify a warning level, the default is WARN-LOW.
If you specify NO-WARN, you must specify a rule-action.
ADD RULE COMP Command 175