Show TOC

MONITOR_REWRITELocate this document in the navigation structure

Definition

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 QueryAnalysisMode support database parameter must be set to EXTENDED and the EnableQueryRewrite special database parameter must be set to YES.

Structure

Value

Explanation

<RULENAME>

Possible rules for the query rewrite as mentioned in system table QUERYREWRITERULES in column RULENAME

Number of usages of the rule '<RULENAME>'

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

More Information