Merge Join Internals in SQL Server | Query Processing: Nested-Loop joins and Merge join
Channel: SS UNITECH
Date: 16/01/2021

#ssunitech #sqlserverperformancetuning
Without additional optimizations, SQL Server's Merge Join algorithm is the fastest physical join operator available.  In this episode we dive into the internals to understand how the merge join algorithm works, as well as what it means for our query performance.