Re: Sincere Advice on Sql Plan - Thanks

From: bill thater <shrek_at_consultant.com>
Date: Wed, 13 Oct 2004 13:08:19 -0500
Message-Id: <20041013180819.2EE56790051@ws1-14.us4.outblaze.com>

> 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_at_consulant.com=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


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

Received on Wed Oct 13 2004 - 13:03:49 CDT