Neoview Workload Management Services Guide (R2.5)

d. In the Value box, enter a value to be compared with the compiler estimate:
Acceptable Comparison ValueCompiler Estimate
The rule expression compares the estimated memory for the query, in
kilobytes, with this numeric value.
Enter a numeric value in kilobytes (KB).
EST_TOTAL_MEMORY
The rule expression compares the estimated time to execute the query, in
minutes, with this numeric value.
Enter a numeric value in minutes.
EST_TOTAL_TIME
The rule expression compares the estimated cardinality (that is, the
estimated total number of rows that the query will return) with this
numeric value.
Enter a numeric value.
EST_CARDINALITY
The rule expression compares the estimated total number of rows that will
be accessed by all the scan, insert, update, and delete operators with this
numeric value.
Enter a numeric value.
EST_ACCESSED_ROWS
The rule expression compares the estimated total number of rows that will
be accessed by scan and insert operators with this numeric value.
Enter a numeric value.
EST_USED_ROWS
The rule expression compares the number of joins in the query plan with
this numeric value.
Enter a numeric value.
NUM_JOINS
The rule expression compares the estimated number of rows that will be
accessed by a full scan of a table with this numeric value.
Enter a numeric value.
SCAN_SIZE
e. Click the [+ Add Expr] button to add the expression to the list in the Expression box.
To clear all the expressions and start over, click the [Clear] button.
f. To add another compilation rule expression, repeat steps 7a through 7e.
NOTE: You can specify up to fifteen compilation rule expressions. WMS evaluates the
expressions in the order in which you specify them.
8. In the Comments box, enter optional text to describe the rule that you are creating.
NOTE: The Command Preview box displays the WMS command that will be issued when
you add the rule.
9. Click the [Add] button to add the compilation rule, or click [Cancel] to quit the dialog box
without adding the rule.
10. Click [OK] when notified that the compilation rule was added successfully.
11. When you are done adding compilation rules, close the Add Rule dialog box by clicking the
[x] icon in the upper right corner.
Compilation Rules 91