RE: Sincere Advice on Sql Plan - Thanks

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Wed, 13 Oct 2004 19:58:55 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNKEOBCJAA.lex.de.haan@naturaljoin.nl>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ganesh Raja Sent: Wednesday, October 13, 2004 18:54
To: jkstill_at_gmail.com
Cc: smishra_97_at_yahoo.com; oracle-l_at_freelists.org 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 13 2004 - 12:54:37 CDT