Joins in SQL Server Execution Plans

First published at 14:39 UTC on August 29th, 2018.
subscribers

Understanding the different join types and where they apply is an important part of reading and understanding execution plans in SQL Server. I introduce the four joins; nested loops, hash, merge and adaptive.

For more on adaptive joins, here'…

MORE
CategoryScience & Technology
SensitivityNormal - Content that is suitable for ages 16 and over
DISCUSS THIS VIDEO