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

Teradata Vantageā„¢ - SQL Request and Transaction Processing

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
User Guide
Publication ID
B035-1142-171K
Language
English (United States)

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.