Hash Bucket Limits - Teradata Database

Teradata Database Administration
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Hash Bucket Limits

 

Parameter

Value

Number of hash buckets per system.

This value is user‑selectable. See the topic “Hash Maps” in Chapter 8 of Database Design for details.

The number is user‑selectable per system.

The choices are:

  •      65,536
  • 1,048,576

    • Bucket numbers range from 0 to the system maximum.

    Size of a hash bucket

    The size depends on the number of hash buckets on the system If the system has:

  • 65,536 hash buckets, the size of a hash bucket is 16 bits.
  • 1,048,576 hash buckets, the size of a hash bucket is 20 bits.

    • Set the default hash bucket size for your system using the DBS Control utility (see Utilities: Volume 1 (A-K) for details).