Some examples of join methods are given as follows:
i. Merge join — Sorts both the joining tables by using the join key and then merges the sorted rows.
ii. Nested loop join — Applies filter conditions specific to the outer table and gets a result set. After that, it joins the inner table with the result set using either an index or a full table scan.
iii. Hash join — Uses hash algorithm for filter conditions on smaller table first and then performs the same hashing algorithm on the other table for joined columns. After that, it returns the matching rows.
i. Merge join — Sorts both the joining tables by using the join key and then merges the sorted rows.
ii. Nested loop join — Applies filter conditions specific to the outer table and gets a result set. After that, it joins the inner table with the result set using either an index or a full table scan.
iii. Hash join — Uses hash algorithm for filter conditions on smaller table first and then performs the same hashing algorithm on the other table for joined columns. After that, it returns the matching rows.
No comments:
Post a Comment