Example: Logging Plans as XML Text for Detailed Statistics - Advanced SQL Engine - Teradata Database

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
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
     BEGIN QUERY LOGGING WITH DETAILED STATSUSAGE ON user_1;

The detailed statistics logged are listed in the following table.

Logged Detailed Statistics
AvgAmpRPV NumBValues NumPNullDistinctVals
CPUUsage NumColumns NumRows
HighModeFreq NumDistinctVals OrigVersion
IOUsage NumEHIntervals PNullHighModeFreq
NumAllNulls NumHistoryRecords StatTimeStamp
NumAMPs NumNulls Version