Multiple choice technology

Which of the following gives better performance improvement technique?

  1. Input serial file -> partition by key ->sort-> reformat->multifile

  2. Input serial file -> sort -> partition by key ->reformat -> multifile

  3. Input serial file -> sort -> reformat-> partition by key -> multifile

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Partitioning by key before sorting significantly improves performance because it reduces the amount of data each partition needs to sort. Sorting serial files before partitioning is inefficient because the entire dataset must be sorted first. The optimal sequence partitions first, then sorts within partitions.

Keep practicing — related questions