Inclusion Join | Join Planning/Optimization | Teradata Vantage - Inclusion Join - Advanced SQL Engine - Teradata Database

SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
uqf1592445067244.ditamap
dita:ditavalPath
uqf1592445067244.ditaval
dita:id
B035-1142
lifecycle
previous
Product Category
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.

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.