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