Re: SQL not working in 10g Release 2

From: Balamurali <bmuralir_at_gmail.com>
Date: 11 Jan 2006 02:04:33 -0800
Message-ID: <1136973873.431748.175480@g14g2000cwa.googlegroups.com>

Hi Laurenz Albe,

The "SQL query" I am having is quite similar to the one I have mentioned.

select column1,.....,columnx from t,(select col1 from t2 where t2.xyz='1234') t2
where t.column1 = t2.col1

What was and is happening in Oracle 10g R1 is that, when I execute this query "t2" is executed only once because it returns only one row. And then it is joined with "t" and then 't' is retrieved once, so there are 2 SELECTs.

But in Oracle 10g R2 't2' is matched with all rows in 't' !! i.e., for every row in 't' , 't2' is retrieved and from that set one row is returned as output.

I hope you get the picture.

Is there any parameter setting which I have to change in R2 to avoid this?

I have gatherd the statistics for all objects.

Thanks in advance.
Regards,
Balamurali Received on Wed Jan 11 2006 - 04:04:33 CST