| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Disable Bind Perforance Issue
Paul Bennett wrote:
>
> 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."
Don't forget the space between the "+" and the "index"...
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Wed Dec 15 1999 - 03:52:29 CST
 |
 |