Tips for hash join

Hash join has several advantages over nested loop join:

Hash join cannot be used for queries that:

The following discourages a hash join from being used:

The following encourages a hash join to be used:

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