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

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. Received on Thu Sep 08 2005 - 15:36:06 CDT