15.00 - Hash Bucket Limits - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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