Re: Sincere Advice on Sql Plan - Thanks

Lex,

Thanks for that .. Yes The New java Pardigm... Getting a Bit
furstrated with that .

Yes i did notice that Discrepancy in the rows no ideas where he gets
that huge count from .

Thanks for Pointing out the Outer Join Differences .. I rewrote th
Queryin the new Way and yes it performs better now .. Will again Look
into this SQL ... to see what they are doing ..

to be very frank i am not very comfortable with the new way ;)

Thanks as always

Rgds
Ganesh
--
http://www.freelists.org/webpage/oracle-l

Other related posts: