HASH JOINS ARE FASTER THAN MERGE JOINS
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- A normal or master outer join performs faster than a full outer or detail outer join.
- union all is faster than union
- UNION ALL is faster than a UNION
- UNION ALL has a comparitively faster performance compared to UNION?
- Which join requires denormalisation of the table
- What is (are) the difference between Lookup, Join and Merge
- What is (are) the difference between Lookup, Join and Merge
- What is the specific partitioning technique should be used for join stage?