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