Re: SQL not working in 10g Release 2

Balamurali <bmuralir_at_gmail.com> wrote:
> 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.

Do you mean that the results returned from the query are different on the two systems, i.e. on 10g R1 it retruns one row and on 10g R2 many?

Or do you mean that the query retruns the same result on both systems, but processes the query in a different way?

Please clarify!

If the former is the case, please double check that the tables contain the same data on both systems.

Yours,
Laurenz Albe Received on Wed Jan 11 2006 - 09:15:46 CST