Re: CBO - hash join vs nested loops

Checked the CDN and NDV for the tables/columns and they seem OK, but I have to check the indexes stats too.
The only think I noticed is that the CBO expects 2076 rows before the final distinct and they are 1401.

I thought it could be something more "obvious" and "easy" :O).

Thanks,
Dimitre Radoulov

• Original Message ----- From: "Christian Antognini" <Christian.Antognini_at_trivadis.com> To: <cichomitiko_at_gmail.com> Cc: <oracle-l_at_freelists.org> Sent: Friday, December 02, 2005 4:32 PM Subject: 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-l