Quiz: Physical Join Operators in SQL Server Execution Plans

Quiz: SQL Server Physical Join Operators 👯‍♀️

Operators are standing by 📞

Learn more

Just to be clear, SQL Server didn’t invent these types of physical joins. These join algorithms are computer science concepts, but I’m talking about their implementation in SQL Server in this quiz.

Microsoft documentation gives a nice brief overview of nested loop joins, merge joins, and hash joins here.