Hash Join Optimization

Merge Vs Hash Join

If the thread is responsible for sorting the page rows and that is blocked by another intensive CPU
query.

We will need to use the hint option (hash join) to instruct the sql to use hash join plan instead of     merge join


Merge Join Plan 




Hash Join Plan 

The query will run faster instead of minutes/hours if that particular thread is very busy on CPU intensive Queries.