Using Outer Joins to Define Join Indexes - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Using Outer Joins to Define Join Indexes

If there is a need for a non-aggregate multitable join index between several large tables, considering using an outer-join to define your join index. This approach offers the following benefits.

  • The Optimizer will consider a join index defined using an outer-join for queries that reference only the outer tables of the defining outer join.
  • The join index preserves the unmatched rows in the outer join within the join index structure.