15.10 - Inclusion Join - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

An inclusion join is a product, merge, or hash join where the first right table row that matches the left row is joined.

There are three 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” on page 468.

    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.

    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.