Re: Disable Bind Perforance Issue

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 14 Dec 1999 22:09:51 +0800
Message-ID: <38564FAF.73B3@yahoo.com>

Paul Bennett wrote:
>
> Why would a query run faster with disable bind vs. using bind variable.
> It is running extremly fast with disbable bind. The query is not
> cached. The query is unique and has not been run before.
>
> Thanks.
>
> -- Paul

Generally you always want bind variables to avoid the parsing overhead. However, if Oracle is making a better optimizer decisions without them, then explain the query and use hints to force this access path with the bind variables as well...

...this should give the best of both worlds.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Dec 14 1999 - 08:09:51 CST