Conclusions
•Hash joins to large
tables can win in cases
where the join order is wrong,
or where join-key indexes are
missing or disabled through join-key
type conversions or other index-disabling
functions.
•(In the above case,
the better solution is to enable
the optimum nested-loops plan!)