16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
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.