Using Outer Joins to Define Join Indexes - Teradata Database

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.