sqldbpool.com
Logical Joins and Physical Joins
Logical Joins: INNER JOIN, RIGHT/LEFT OUTER JOIN, CROSS JOIN, OUTER APPLY. This joins are written by the user. Physical Joins: Nested loop, merge join and hash join is common operators which we wil…