Inclusion Join | Join Planning/Optimization | Teradata Vantage - Inclusion Join - Analytics Database - Teradata Vantage

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.

Also see Inclusion and Exclusion Product Joins with Dynamic Row Partition Elimination.

Inclusion Merge Join Process

1. Read each row from the left table.
2. Join each left table row with the first right table row having the same hash value.

Inclusion Product Join Process

1. For each left table row read all right table rows from the beginning until one is found that can be joined with it.
2. Return the left row if a matching right row is found for it.