Skip to content


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.

Posted in /Technology. Tagged with , .

0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

Some HTML is OK

(required)

(required, but never shared)

or, reply to this post via trackback.