Re: 10g Performance: its crawling

  • From: Nuno Souto <dbvision@xxxxxxxxxxxx>
  • Date: Sun, 31 Dec 2006 22:15:39 +1100

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


Other related posts: