O'Reilly logo

Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition by Tom Coffing, William Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required