15.00 - Uniform Data Distribution - Teradata Database

Teradata Database Design

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

Uniform Data Distribution

With respect to uniform data distribution, you should always consider the following factors.

  • The more distinct the primary index values, the better.
  • Rows having the same primary index value are distributed to the same AMP.
  • Parallel processing is more efficient when table rows are distributed evenly across the AMPs.
  • See “Distribution Demographics” on page 416 for details.