Re: using bind variables makes the optimizer choose a bad plan

On Thu, 8 Sep 2005 22:36:06 +0200, boogab00_at_yahoo.com wrote (in article <1126211766.498568.107440_at_g14g2000cwa.googlegroups.com>):

> In my experience, bind-peeking in 9i releases cause more trouble than
> it can be worth. It must be an expensive function because it will only
> peek at a cursor once, and use the same execution plan for subsequent
> identical cursors. So you must hint, use outlines or turn it off.
>

You can also switch the peek bind totally off. If you need that you may ask yourself about the quality of the indexes ...

With kind regards / met vriendelijke groeten, Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle Received on Sat Sep 10 2005 - 02:02:56 CDT