Joins Dissected on CraigFr's blog
CraigFr has a great series of posts in his blog describing the difference between the various logical and physical join types, the details of how SQL Server implements these joins, and the things that the query optimizer takes into account when selecting a join type. These five posts are a wonderful read.
- Overview of Logical Join Types (Inner/Outer/Cross/Semi/Anti-Semi/Cross Apply)
- Nested Loop Joins Dissected
- Merge Joins Dissected
- Hash Joins Dissected
- How SQL chooses which physical join operator to use
"Joins" Post Category: https://blogs.msdn.com/craigfr/archive/category/14122.aspx