Conclusions
•Nested loops almost
always win when the CBO prefers
them.
•Hint-forced nested
loops usually win when the
CBO underestimates the
combined selectivity of multiple filters
(when mutually-exclusive conditions
violate the assumption of
statistically independent conditions).