Which partition is the most efficient one?
-
Same
-
Entire
-
Hash By Key
-
Round robin
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.