How many types of join methods?

@ : Home > > Interview Room

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.

Alert me