15.00 - BEGIN QUERY CAPTURE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

BEGIN QUERY CAPTURE

About BEGIN QUERY CAPTURE

BEGIN QUERY CAPTURE has the same functionality as the following form of BEGIN QUERY LOGGING except that Teradata Database does not capture the XML query plans in DBQL logs, but in a QCD.

     BEGIN QUERY LOGGING WITH XMLPLAN,STATSUSAGE,VERBOSE,STATSDETAILS;

Teradata Database does not capture the XML plans in DBQL logs to ensure that NO EXEC queries are not be mixed in the DBQL logs along with executed queries. Instead, the system captures the XML plans in the QCD table XMLQCD.

Unlike DBC.DbqlRuleTbl, which is maintained for query logging, Teradata Database does not maintain query capture rules in a query capture database because the scope of BEGIN QUERY CAPTURE requests is at session level only.