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. |