Re: Disable Bind Perforance Issue

That sounds like a great idea, except when I do a explain plan on both a static query and one that has bind variables, the plan is exactly the same.

Now what?

Also, oracle seems to ignore my hints. For example, if oracle is doing a full table scan on something, but I want it to use the index, I can add the +index(table index) hint and it just ignores it. Are there other hints I might need to add in addition?

• Paul

Connor McDonald wrote:

> 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 - 16:45:50 CST