Chapter 43 - Hashing Functions
“Love, like a chicken salad or restaurant hash, must be taken with blind faith or it loses its flavor.”
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:
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 ...