“Following the light of the sun, we left the Old World.”
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 ...