Merge Join Internals in SQL Server

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.

Subscribe and turn on notifications to never miss a weekly video: https://www.seevid.ir/c/DataWithBer...

Related blog post about Merge Joins:
https://bertwagner.com/2018/12/18/vis...

Be sure to check out part 1 on nested loops joins: The Importance of Nested Loops Joins ...

And part 3 on hash match joins: Hash Match Join Internals in SQL Server

The pessimistic costing of merge joins:
https://dba.stackexchange.com/questio...

Going further in-depth with merge joins:
https://sqlserverfast.com/epr/merge-j...

Follow me on Twitter:
Twitter: bertwagner

• #science_technology
• #sql_server
• #sql
• #sql_training
• #sql_tutorial
• #merge_join
• #join_algorithms
• #merge_join_algorithm
• #internals