Tag: Merge Join

Discovering More About Join Operator Internals

Post author By Andy B.
Post date Aug 26, 2025
1 Comment on Discovering More About Join Operator Internals

In the previous post I explained Join Operators in SQL Server. Whilst compiling that I dug a little deeper and came across a few interesting points I thought were worth sharing. Let’s look at behaviour of the operators which may occur under specific conditions. Hopefully you find them as interesting as I did: Optimised nested loop […]

Tags Hash Join, Hash Match Join, Join Operators, Merge Join, Nested Loop Join, SQL, SQL Server

SQL Server

SQL Server Join Operators Explained

Post author By Andy B.
Post date Aug 19, 2025
1 Comment on SQL Server Join Operators Explained

When reviewing our execution plans we’ll see joins executed using different operators. The type of operator is chosen based on the data that’s available to join and how the optimiser wants to execute it. In this post we’ll take a look at what the operators are, when they are used, and how they work. These […]

Tags Hash Join, Hash Match Join, Joins, Merge Join, Nested Loop Join, Querying, SQL, SQL Server