15.10 - MODE=m - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.