16.20 - MODE=m - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

CPU and I/O data collection mode to use, where m is a number from 0 through 3.

For more information about these options, see “Tracking Query Behavior with Database Query Logging” in Teradata Vantage™ - Database Administration, B035-1093.

0
Use the default data collection algorithm for this Teradata Database release (algorithm 1).
1
Use the classic V2R6 algorithm 1 for step adjustments. This is the default.
2
Use AMP algorithm 2, diagnostic only.
3
Use AMP algorithm 3, which includes data on aborted and parallel steps.