Question
What is a semi-join optimization?
Select an option. Your answer will be checked instantly.
Correct Answer: B. Filtering one join input using keys obtained from the other input
Explanation:
A compact key set can eliminate records that cannot match.
This reduces the amount of data sent through the full join.
Leave a Reply