Different Join Types
April 28th, 2005
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.









Recent Comments