O'Reilly logo

Teradata Basics for Business Users by Tom Coffing, Leona 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 5 -Three Options for Teradata Table Design

“Design is not just what it looks like and feels like. Design is how it works.”

- Steve Jobs

There are Three Options to Teradata Table Design

1. Traditional Teradata using a Primary Index:

80-90% of your tables will use the traditional Teradata design of simply having a Primary Index. These tables will distribute the rows of the table among the AMPs with a consistent and straightforward Hash Formula. The AMPs will sort their rows by the Primary Index value (kind of) and when a user queries the table using the Primary Index value to limit the rows returning it will always be a “Single AMP retrieve”.

2. Partition the table which is called a PPI Table (Partition Primary Index):

Teradata allows ...

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