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_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l