17.10 - BEGIN QUERY CAPTURE Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
FOR INDEX_ANALYSIS
Insertions are made into the following tables of the specified Query Capture Database:
  • Query or QryRelX
  • Workload
  • WorkloadQueries
  • Field
  • XMLQCD
VERBOSE
Capture verbose EXPLAIN text.
DETAILED
Capture summary statistics details for all of the database objects referenced in the query plan for the request, in addition to capturing Optimizer statistics usage and recommendation information. When you specify DETAILED, the request captures the following statistics details for all the database objects referenced in the query plan:
  • StatTimeStamp
  • Version
  • OrigVersion
  • NumColumns
  • NumBValues
  • NumEHIntervals
  • NumHistoryRecords
  • NumNulls
  • NumAllNulls
  • NumAMPs
  • NumPNullDistinctVals
  • PNullHighModeFreq
  • AvgAmpRPV
  • HighModeFreq
  • NumDistinctVals
  • NumRows
  • CPUUsage
  • IOUsage
STATSUSAGE
Capture Optimizer statistics usage and recommendation information.
qcd_name
The name of the QCD database to be used to capture and store the query plan data.
If you do not specify a QCD database, Vantage uses the QCD database named TDQCD by default.
For more information about TDQCD, see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.
workload_name
The name of the workload to which the requests submitted within a BEGIN QUERY CAPTURE session belong.