Multiple choice technology

Which partition is the most efficient one?

  1. Same

  2. Entire

  3. Hash By Key

  4. Round robin

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

Round-Robin is often considered the most efficient partitioning method because it requires no computation - rows are simply distributed in rotation to each partition. Same requires no movement but keeps existing distribution, Entire is expensive (broadcasts all data), Hash requires hash computation. Round-Robin's simplicity makes it fastest for even distribution.