17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K
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.