The Importance of Nested Loops Joins in SQL

Nested Loops Joins are one of the primary physical join operators used by SQL Server. In today's episode we discuss how Nested Loops Joins work, as well as how to use that knowledge to troubleshoot a slow performing query's execution plan.

Subscribe and turn on notifications to never miss a weekly video: https://www.youtube.com/c/bertwagner?sub_confirmation=1

Related blog post with code snippets:
https://bertwagner.com/2018/12/11/visualizing-nested-loops-joins-and-understanding-their-implications/

Be sure to check out part 2 on merge joins: https://youtu.be/IFUB8iw46RI

And part 3 on hash match joins: https://youtu.be/59C8c7p_hII

Additional excellent blog posts that go further in-depth:
https://blogs.msdn.microsoft.com/craigfr/2006/07/26/nested-loops-join/
https://sqlserverfast.com/epr/nested-loops/

Follow me on Twitter:
https://twitter.com/bertwagner

Видео The Importance of Nested Loops Joins in SQL канала Bert Wagner