Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan changes if using bind vars
NetComrade wrote:
> On Wed, 03 Aug 2005 04:16:51 GMT, Mladen Gogala <gogala_at_sbcglobal.net>
> wrote:
>
> >On Tue, 02 Aug 2005 16:40:57 +0000, NetComrade wrote:
> >
> >> I have a query that changes explain plan for the worse if I change
> >> non-bind vars to bind vars. Discovered this yesterday, when was trying
> >> to figure out extra dblink chatter (see reduce dblink (database link)
> >> chatter thread)
> >
> >Things usually develop from bad to worse, as is clearly explained here:
> >http://www.cpuidle.de/murphy.shtml
> >If everything looks good, you overlooked something.
> >
> >For bad cases like your query, there are hints which will probably do the
> >trick. CBO is not bulletproof and there are cases when you must use hints
> >to get the desired results. That's what they're here for.
>
>
> I wish there was a hint to make the query execute subquery remotedly,
> and don't bother trying to figure out the explain plan.. I couldn't
> figure out how to do that..
DRIVING_SITE, perhaps?
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref.htm#5699
Received on Thu Aug 04 2005 - 02:13:44 CDT