Definition of the Inclusion Join
An inclusion join is a product, merge, or hash join where the first right table row that matches the left row is joined.
Following are the types of inclusion join:
- Inclusion merge join
- Inclusion product join
- Inclusion hash join
Inclusion Merge Join Process
- Read each row from the left table.
- Join each left table row with the first right table row having the same hash value.
Inclusion Product Join Process
- For each left table row read all right table rows from the beginning until one is found that can be joined with it.
- Return the left row if a matching right row is found for it.