BEGIN QUERY CAPTURE Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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 the database objects referenced in the query plan for the request. Capture 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.
workload_name
The name of the workload to which the requests submitted within a BEGIN QUERY CAPTURE session belong.