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):