15.00 - Using Outer Joins to Define Join Indexes - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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.