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.