Multiple choice technology

The order of the ports used in joining condition must match the order Of the ports at the sort origin

  1. True

  2. False

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

Port order in JOIN conditions does not need to match port order at the sort origin. These are independent specifications - the JOIN defines relationships, while SORT defines ordering. The optimizer handles them separately.