Multiple choice technology databases

In Which way is data distributed with a partitioned primary index?

  1. Based on the secondary unique index

  2. Based on the Primary key of the table

  3. Based on the Primary Index of the table

  4. Based on the partitioning column

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

With Partitioned Primary Index (PPI), data is first distributed based on the Primary Index (PI) across AMPs, then partitioned within each AMP based on the partitioning column. The primary distribution mechanism is still the Primary Index hash. Secondary index and primary key don't control distribution in PPI.

Keep practicing — related questions