BEGIN QUERY CAPTURE Syntax Elements - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™
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.