Conclusions
•Hint-Forced nested
loops in the best join order usually win in the common
case of joins from recent rows
to related recent rows (joins between
naturally co-clustered tables).
•Hash joins to
large full table scans are
rarely better than the best nested-loops plan.