15.10 - MODE=m - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

CPU and I/O data collection mode to use, where m is one of the following.

For detailed information about these options, see “Tracking Query Behavior with Database Query Logging” in 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.