Re: 10g Performance: its crawling

MVR wrote,on my timestamp of 30/12/2006 8:34 PM:


Just an FYI. The query is having bad condition in where clause.

           AND fcl.application_id(+) = 800
           AND fcl.lookup_type(+) = 'NATIONALITY'
Its causing MERGE Cartesian Join, its causing an extra courtesian join in 10g. 

There are two solutions I found 1. Creating a SQL profile which
doesn't use cortesian jon 2. removing (+) from conditons listed
above..

So I got it back to 33 mins from 4+ hours.




That's good news.  The bit that still worries
me is the "removing (+) from conditions listed above":
that will change an outer join to an inner join and
cause incorrect results for sure?

--
Cheers
Nuno Souto
dbvision@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: