17.05 - m - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Specifies the CPU and I/O data collection mode algorithm to use:

m Algorithm
0 1, the data collection algorithm.
1 Classic V2R6 algorithm 1 for step adjustments.
2 AMP algorithm 2, diagnostic only.
3 (default) AMP algorithm 3, which retrieves statistics on parallel steps using AMP coordination and captures aborted step usage data.

For information about these options, see Teradata Vantage™ - Database Administration, B035-1093.