Chapter 43 - Hashing Functions

“Love, like a chicken salad or restaurant hash, must be taken with blind faith or it loses its flavor.”

-Helen Rowland

Hashing Functions on Teradata

Teradata uses Parallel Processing, and the most important aspect of this is to spread the rows of a table equally among the AMPs who read and write data.

Below, are the four Hashing Functions available to see the distribution of data:

images

 

Teradata uses parallel processing with its architecture of AMPs and PEs. The Primary Index (PI) must exist whenever you create a table because it is the sole determinant of which AMPs owns which rows. This concept pertains to data ...

Get Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.