17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)
SettingsV stores settings that are used by the stored procedures and views.
Changes to SettingsTbl should only be made to the DefaultValue column. Please contact Teradata Support for assistance before making changes to SettingsTbl.

Possible Values for DefaultValue

Setting Default Value Description
ANALYZER_LOG_LEVEL 1 Level of logging into AnalyzeLogTbl. 0 means logging is turned off; 1 means logging is on.
GROUPING_WEIGHT_FACTOR_COST 1.0 Weight factor in Grouping Tables - Step Cost
GROUPING_WEIGHT_FACTOR_FREQ 1.0 Weight factor in Grouping Tables - Frequency
MOVER_LOG_LEVEL 1 Level of logging into LogTbl. 0 means logging is turned off; 1 means logging is on.
MULTI_AMP_MAP_FACTOR 1.0 The number of AMPs in a multi-AMP sparse map is the number of nodes divided by this factor.
SINGLE_AMP_MAP_SIZE_FACTOR 1.0 The additional size limit multiplier for a table in a one-AMP sparse map.
SMALL_TABLE_SIZE_LIMIT 131072 The maximum per-AMP size for a table in a sparse map.
TABLE_HEADER_SIZE 1024 The size of the table header for a simple table with a few columns.
USE_PEAK_PERM Y If Y, then the peak perm value is used for sparse table candidates, otherwise the current perm is used.