“Design is not just what it looks like and feels like. Design is how it works.”
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 ...