Common
Cases to Consider
•Nested-loops join reaches a large
fraction of a small joined-to table: Optimizer tends to prefer
a hash join, correctly, but both alternatives are well-cached
and fast.
•Nested loops obviously reach a tiny
fraction of a large joined-to table: Optimizer tends to prefer
a nested-loops join, correctly, and this is much faster than
the hash-join alternative.