Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CBO - hash join vs nested loops
Dimitre
>Subject: CBO - hash join vs nested loops
Did you compare the estimated cardinalities with the real one? If not, it's the right place to start... In fact with 3 conditions it's quite easy to mislead the CBO.
HTH
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 02 2005 - 09:34:26 CST
![]() |
![]() |