Multiple choice technology databases

In which way is data distributed with a Partitioned Primary Index?

  1. It is based on the Secondary Index

  2. It is based on the primary key of the table

  3. It is on the partitioning column

  4. It is based on the Primary Index of the table
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

With a Partitioned Primary Index (PPI), data distribution across AMPs is still determined by the Primary Index hash value, just like a regular PI. The partitioning component adds a secondary organization layer within each AMP, but does not affect how rows are distributed to AMPs initially. The partitioning column defines how data is organized within each AMP, not across AMPs.

Keep practicing — related questions