MONITOR_REWRITE

Definition

The monitor system table 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 parameter OPTIMIZE_QUERYREWRITE must contain the value OPERATOR.

Structure

DESCRIPTION Column

Value

Explanation

EliminateOrderBy

Number of usages of the rule 'EliminateOrderBy'

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'

DistinctPushDownTo

Number of usages of the rule 'DistinctPushDownTo'

DistinctPushDownFrom

Number of usages of the rule 'DistinctPushDownFrom'

DistinctForSubqueries

Number of usages of the rule 'DistinctForSubqueries'

SimplifyPredicates

Number of usages of the rule 'SimplifyPredicates'

EliminateGroupByOrDistinct

Number of usages of the rule 'EliminateGroupByOrDistinct'

PushDownPredicates

Number of usages of the rule 'PushDownPredicates'

PushDownProjection

Number of usages of the rule 'PushDownProjection'

PushDownQuantifier

Number of usages of the rule 'PushDownQuantifier'

The sequence of the information in the DESCRIPTION column can change.

See also:

MONITOR

Concepts of the Database System, Special Database Parameters