Re: Sincere Advice on Sql Plan - Thanks
- From: "bill thater" <shrek@xxxxxxxxxxxxxx>
- To: ganesh.raja@xxxxxxxxx, jkstill@xxxxxxxxx
- Date: Wed, 13 Oct 2004 13:08:19 -0500
> Okay I am Going to Piggy Back on this ..=20
>=20
> 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.
>=20
> There is a Total Change in the plan and it works much faster than the
> ANSI Counterpart
could it be because the optimizer is designed to use Oracle syntax?
--
Bill "Shrek" Thater ORACLE DBA=20=20=20=20=20
shrek@xxxxxxxxxxxxx=20
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--=20
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
--
//www.freelists.org/webpage/oracle-l
Other related posts:
