The following rules and restrictions apply to the BEGIN QUERY CAPTURE statement.
BEGIN QUERY CAPTURE and BEGIN QUERY LOGGING
BEGIN QUERY CAPTURE has the same functionality as the following form of BEGIN QUERY LOGGING, except that the XML query plans are captured in a query capture database (QCD) instead of DBQL logs.
BEGIN QUERY LOGGING WITH XMLPLAN,STATSUSAGE,VERBOSE,STATSDETAILS;
Teradata Database does not capture the XML plans in DBQL logs, ensuring that NO EXEC queries are not mixed with executed queries in the DBQL logs. Instead, the system captures the XML plans in the QCD table XMLQCD.
The scope of BEGIN QUERY CAPTURE is at the session level, not at the user level like BEGIN QUERY LOGGING. Unlike DBC.DbqlRuleTbl, which is maintained for query logging, Teradata Database does not maintain query capture rules in a query capture database. For more information about the relationship between BEGIN QUERY CAPTURE and BEGIN QUERY LOGGING, see Teradata Vantage™ - Database Administration, B035-1093.
BEGIN QUERY CAPTURE supports the same statement types as BEGIN QUERY LOGGING.
You cannot submit a BEGIN QUERY LOGGING request for a user that has an active BEGIN QUERY CAPTURE session.
Query Banding and BEGIN QUERY CAPTURE
You can use query banding with BEGIN QUERY CAPTURE statements, but you cannot enable or disable query banding within the scope of a BEGIN QUERY CAPTURE and END QUERY CAPTURE statement pair.
Teradata Database captures the name of the query band used and stores it in the QCD XMLQCD table.
VERBOSE Option for BEGIN QUERY CAPTURE
When you specify the VERBOSE option for BEGIN QUERY CAPTURE, the logged XML document contains details on Object, SQL, Step Details, and Verbose EXPLAIN text regardless of whether you specified the XMLPLAN option.
Teradata Database logs the Verbose EXPLAIN text in the existing <PlanStep>@StepText attribute.
STATSDETAILS and XMLPLAN Options
When you specify the STATSDETAILS option but not the XMLPLAN option, the logged XML document contains details on Object, SQL, Step Details, and Statistics Details from Statistics header and Statistics Recommendation DDLs.
When you specify both STATSDETAILS and XMLPLAN, Teradata Database logs a single integrated document containing data from both options.
Teradata Database logs Object, SQL, and Step Details only once. Statistics Details from the Statistics Header are logged into a new XML element.
BEGIN QUERY CAPTURE Statement Scope
You cannot submit a BEGIN QUERY CAPTURE statement within the scope of a previously submitted BEGIN QUERY CAPTURE statement.