Neoview Workload Management Services Guide (R2.4)

comp-expression
specifies one of these compilation rule expressions:
An expression comparing the estimated total memory
per CPU used by 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 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 classification. 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.
rule-action
specifies an action to take if rule-specifier-list evaluates to true. If you specify a
NO-WARN warn-level, you must specify a rule-action. For a compilation rule, you
can specify one of these actions:
REJECT | HOLD | { EXEC "sql-string;" }
REJECT
causes the query to be rejected.
ALTER RULE COMP Command 95