RE: Sincere Advice on Sql Plan - Thanks

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <ganesh.raja@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Oct 2004 19:58:55 +0200

you might want to provide the two statements you are talking about?
and maybe even the two corresponding execution plans?
 
Kind regards,
Lex.
 
-------------------------------
visit http://www.naturaljoin.nl
-------------------------------
skype me <callto://lexdehaan>
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ganesh Raja
Sent: Wednesday, October 13, 2004 18:54
To: jkstill@xxxxxxxxx
Cc: smishra_97@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Sincere Advice on Sql Plan - Thanks

Okay I am Going to Piggy Back on this .. 

I have an ANSI SQL which when Rewriiten Using Oracle Syntax it seems
to take a Better plan to execute it .. Any ideas why this is
happening.

There is a Total Change in the plan and it works much faster than the
ANSI Counterpart

Any help is appreciated.

Thanks.

Cheers
Ganesh R



--
//www.freelists.org/webpage/oracle-l

Other related posts: