Chapter 3 – Laying out and Retrieving Data

“I don’t know who my grandfather was. I am more interested in who his grandson will become.”

– Abraham Lincoln, 16th president of the United States


Teradata freed the AMPs from doing everything together by giving each table a Primary Index. The Primary Index is the column(s) that lays out the data row to the proper AMP and the Primary Index column(s) is also the fastest way to retrieve a row from that same AMP. Follow this part closely because this is fundamentally the most important subject you will learn about Teradata.

Teradata takes a table and spreads the rows across the AMPs one row at a time. A Unique Primary Index on the table will spread the data rows perfectly evenly across the AMPs. ...

Get Tera-Tom on Teradata Physical Implementation V12-V13 now with O’Reilly online learning.

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