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

Structure

MONITOR_REWRITE, DESCRIPTION Column
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

MONITOR

Database Administration, Special Database Parameters, Support Database Parameters