Conclusions
•The join method to
small tables matters
little, but tends to slightly favor
hash joins for queries returning
substantial rowcounts.
•Hash joins to large
tables can win in rare cases
where sensible queries
return (or summarize) very high
rowcounts.