RE: CBO - hash join vs nested loops

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <cichomitiko@xxxxxxxxx>
  • Date: Fri, 2 Dec 2005 16:32:17 +0100

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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2005