15.00 - Rules and Restrictions for 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)

Rules and Restrictions for BEGIN QUERY CAPTURE

The following rules and restrictions apply to the BEGIN QUERY CAPTURE statement.

  • You can use query banding with BEGIN QUERY CAPTURE requests, but you cannot enable or disable query banding within the scope of a BEGIN QUERY CAPTURE/END QUERY CAPTURE request pair.
  • Teradata Database captures the name of the query band used and stores it in the QCD XMLQCD table.

  • Unlike BEGIN QUERY LOGGING, BEGIN QUERY CAPTURE works at the session level and is not supported at the user level.
  • All the statement types that are currently supported for the BEGIN QUERY LOGGING statements are also supported for BEGIN QUERY CAPTURE.
  • Note: BEGIN QUERY CAPTURE does not capture query plans for the EXPLAIN request modifier or for the INSERT EXPLAIN and DUMP EXPLAIN statements.

  • 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.

    Note: Verbose EXPLAIN text always includes the normal EXPLAIN text for a request.

  • 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.

  • You cannot submit a BEGIN QUERY CAPTURE request within the scope of a previously submitted BEGIN QUERY CAPTURE request.
  • Otherwise, the system returns an error to the requestor.

  • You cannot submit a BEGIN QUERY LOGGING request for a user that has an active BEGIN QUERY CAPTURE session.
  • Otherwise, the system returns an error to the requestor.