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)

The CPU and I/O data collection mode to use. For information about these options, see “Tracking Query Behavior with Database Query Logging” in Database Administration, B035-1093.

m is one of the following:

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.