16.20 - Purpose of REPLACE QUERY LOGGING - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

REPLACE QUERY LOGGING is identical to BEGIN QUERY LOGGING except that it enables you to replace an existing query logging rule in DBC.DBQLRuleTbl by submitting a request to replace that rule with a new rule that has the options you specify for it. The following table is a high level summary of what a REPLACE QUERY LOGGING request does.

IF a rule … THEN Teradata Database …
exists replaces it.
does not exist creates one that satisfies the REPLACE QUERY LOGGING specifications.

See BEGIN QUERY LOGGING for more information relevant to this statement.