Chapter 4 - Partition Primary Index (PPI) Tables

“I saw an angel in the marble and carved until I set him free.”

- Michelangelo

The Concept behind Partitioning a Table

1. Each Table in Teradata has a Primary Index unless it is a NoPI table.

2. The Primary Index is the mechanism that allows Teradata to physically distribute the rows of a table across the AMPs.

3. AMPs Sort their rows by the Row-ID, so the system can perform a lightning fast Binary Search since the rows are in Row-ID Order.

4. Partitioning merely tells the AMP to sort its tables’ rows by the Partition first, but then sort the rows by Row-ID within the partition.

5. Partitioning queries will involve all AMPs, but partitioned tables are designed to prevent FULL Table Scans.

The basic ...

Get V14 Certification: Teradata Basics now with O’Reilly online learning.

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