Different Join Types

There are 3 main ways a database can choose to execute a join between two tables. In no particular order they are:

• Nested-loops Join
• Sort-Merge Join
• Hash Join

I’ll take each of these in turn, explain the differences and in what circumstances you might pick one over another.