Tips for nested loop join

A nested loop join is often used if one or more of these conditions exist:

The following conditions are needed for optimal nested loop join performance:

For more information, see Database Performance and Query Optimization in the Information Center Link to Information center.