O'Reilly logo

Tera-Tom on Teradata Physical Implementation V12-V13 by Tera-Tom 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 4 – The Row-ID

“Following the light of the sun, we left the Old World.”

– Christopher Columbus

I have a feeling you are going to sail through this chapter and discover a whole new world. You are about to learn how the AMP gets their rows organized in ship shop shape.

We already know that Teradata places rows on an AMP by Hashing the Primary Index, which returns a Row Hash value, which is then equated to a number ranging from one to one million, which equates to a bucket in the Hash Map, which points to an AMP number in which the row will reside.

When the row is placed on the AMP the Row Hash that was derived by Hashing the Primary Index will be placed at the front of the row. The AMP will sort the rows that it owns for the table ...

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