Loading

SQL SERVER Execution Plan - Which Join is Expensive and Which Join is Faster ?

Manikavelu Velayutham

16y3.6k

In the sql server execution plan, there were different types of joins like Hash, Merge & Loop. Can any one tell me which join will take longer time and which one will take less time to execute ?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Dipal Choksi16y ago
Typically hash joins are considered to be the worse performers and are advised to be used only when there are no indexes on the joined tables or for queries with parallel execution plans.