16.10 - Inclusion Join - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
User Guide
featnum
B035-1142-161K

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

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.