15.00 - Effect of Hash Bucket Size Changes - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

Effect of Hash Bucket Size Changes

When changing the size of hash buckets, reconfig redistributes every row on the system. This requires a large amount of free space, and requires substantial time because reconfig maintains both the old and the new rows throughout the redistribution process. Consequently, if the purpose of the reconfiguration is only a change in hash bucket size, it may be preferable to run sysinit and restore the data from a backup, which would not require as much memory and time. For more information on changing hash bucket sizes, see the description of NewHashBucketSize section in the DBS Control chapter of Utilities.