Multiple choice technology databases

For PPI table, rows are first sorted by ------ at each AMPs

  1. Hash Value

  2. Partition Number

  3. First column of the table

  4. Both a and b
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In PPI (Partitioned Primary Index) tables, rows are first organized by partition number at each AMP, then by hash value within each partition. This two-level sorting (partition then hash) enables efficient partition elimination in queries. Option B correctly states that rows are first sorted by Partition Number.

Keep practicing — related questions