17.05 - 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.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
mdr1472255012272
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.