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