
The system table <DATABASE_SYSTEM_ADMINISTRATOR>.QUERYREWRITERULES contains the description about possible and activated rules for the query rewrite.
|
RULENAME |
CHAR(32) |
Name of the rule |
|
ACTIVE |
CHAR(3) |
Rule can be applied (YES | NO) |
|
CONNECT |
CLOB |
Comment on the rule |