16.10 - SkewAllowance - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Makes allowance for data skew in the build relation. SkewAllowance specifies a percentage factor used by the Optimizer in choosing the size of each hash join partition.

SkewAllowance reduces the memory size for the hash join specified by HTMemAlloc. This allows the Optimizer to take into account a potential skew of the data that could make the hash join run slower than a merge join.

Field Group

Performance

Valid Range

20 though 80%

Default

75%

This is the recommended setting.

Changes Take Effect

After the DBS Control Record has been written.

Related Topics

For related information, see HTMemAlloc.