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

boogab00_at_yahoo.com schrieb:
> 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.
>

Not bind peeking ist costy, but if you want an inividual plan computed each tome a statement is used why use bind variables? All good achieved by using bind variables will be lost, if the plan is computed each time.

Greetings

Matthias Received on Fri Sep 09 2005 - 15:06:33 CDT