O'Reilly logo

Teradata Architecture for IT and Developers by Tom Coffing, John Nolan

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 6 - 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 concepts ...

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