MONITOR_REWRITE 
The monitor system table <DATABASE_SYSTEM_ADMINISTRATOR>.MONITOR_REWRITE contains information about which query rewrite rules have been used how frequently to simplify an SQL statement.
For the rules to be applied by the application, the EnableQuery database parameter must be set to EXTENDED and the EnableQueryRewrite database parameter must be set to YES.
Structure
Value |
Explanation |
|---|---|
EliminateSubqueries |
Number of usages of the rule 'EliminateSubqueries' |
OptimizerSubqueries |
Number of usages of the rule 'OptimizerSubqueries' |
SimplifyPredicates |
Number of usages of the rule 'SimplifyPredicates' |
EliminateOrderBy |
Number of usages of the rule 'EliminateOrderBy' |
EliminateGroupByOrDistinct |
Number of usages of the rule 'EliminateGroupByOrDistinct' |
RemoveConstFromGroupOrOrderBy |
Number of usages of the rule 'RemoveConstFromGroupOrOrderBy' |
MergeFromSelectOrView |
Number of usages of the rule 'MergeFromSelectOrView' |
MergeExistentialSubquery |
Number of usages of the rule 'MergeExistentialSubquery' |
ConvertExistentialSubquery |
Number of usages of the rule 'ConvertExistentialSubquery' |
ConvertToExistentialSubquery |
Number of usages of the rule 'ConvertToExistentialSubquery' |
DistinctPullUp |
Number of usages of the rule 'DistinctPullUp' |
DistinctForSubqueries |
Number of usages of the rule 'DistinctForSubqueries' |
DistinctPushDownTo |
Number of usages of the rule 'PushDownTo' |
DistinctPushDownFrom |
Number of usages of the rule 'PushDownFrom' |
PushDownPredicates |
Number of usages of the rule 'PushDownPredicates' |
PushDownProjection |
Number of usages of the rule 'PushDownProjection' |
PushDownQuantifier |
Number of usages of the rule 'PushDownQuantifier' |
ConvertOrToIn |
Number of usages of the rule 'ConvertOrToIn' |
NormalizePredicates |
Number of usages of the rule 'NormalizePredicates' |
AddLocalPredicates |
Number of usages of the rule 'AddLocalPredicates' |
The sequence of the information in the DESCRIPTION column can change.