Neoview Workload Management Services Guide (R2.5)

ADD RULE COMP COMPRULE5 (OR,
EST_TOTAL_MEMORY > 320000,
EST_CARDINALITY >= 1000000,
EST_ACCESSED_ROWS > 20000,
EST_USED_ROWS > 20000,
SCAN_SIZE > 10000,
CROSS_PRODUCT,
NO-WARN,
REJECT) COMMENT "Created by DBA on 5/14/2010";
• This command adds a compilation rule that sets the warning level to medium if statistics
are missing for a single-column group:
ADD RULE COMP COMPRULE6 (UPDATE_STATS_WARNING, WARN-MEDIUM)
COMMENT "Created by DBA on 5/14/2010";
ADD RULE COMP Command 177