Topic : Joins

Explain some examples of join methods.

Answer :

Join methods are of mainly 3 types.

Merge Join -
- Sorting both the tables using join key and then merge the rows which are sorted.
Nested loop join -
- It gets a result set after applying filter conditions based on the outer table.
- Then it joins the inner table with the respective result set.
Hash join -
- It uses hash algorithm first on smaller table and then on the other table to produce joined columns. After that matching rows are returned.

Show Answer Discuss