If you need a nonaggregate multiple-table join index between large tables, considering using an outer-join to define your join index. This approach offers the following benefits.
- The Optimizer considers 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.