15.00 - BEGIN QUERY CAPTURE - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.