Re: explain plan changes if using bind vars

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.

-- 
http://www.mgogala.com