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: kzitem.info...
Related blog post about Merge Joins:
bertwagner.com/2018/12/18/vis...
Be sure to check out part 1 on nested loops joins: • The Importance of Nest...
And part 3 on hash match joins: • Hash Match Join Intern...
The pessimistic costing of merge joins:
dba.stackexchange.com/questio...
Going further in-depth with merge joins:
sqlserverfast.com/epr/merge-j...
Follow me on Twitter:
/ bertwagner
Негізгі бет Ғылым және технология Merge Join Internals in SQL Server
Пікірлер: 15