Ending All DBQL Logging - Teradata Database

Ending All DBQL Logging

Use the END QUERY LOGGING ON ALL RULES statement to eliminate all rules currently in the DBQLRuleTbl table using the ON ALL RULES option. For example:

END QUERY LOGGING ON ALL RULES;

The system will:

Delete rules from the DBQLRuleTbl.

Set the DBQLRuleCountTbl.NumberOfRules field to 0.

Flush all rules caches.