On Oct 2, 4:26 am, Niall Litchfield <niall.litchfi..._at_gmail.com>
wrote:
> On Oct 1, 5:03 pm, csn..._at_gmail.com wrote:
>
> > > It's more fundamental than that, even. These two statements are
> > > different as far as parsing is concerned:
>
> > > SELECT * FROM emp WHERE ename = l_variable;
>
> > > select * from EMP where ENAME = L_VARIABLE;
>
> > The parsing would not have changed the plan, but the bind variable
> > peeking may have - in which case it would not have been a new problem.
>
> and bind variable peeking takes place when? Rhetorical question to
> which the answer tends to be - when you don't want it to - but
> certainly when hard parsing as when, for example a sql prettifier
> happens to your code.
My point was hard-parsing wouldn't have made any difference unless
there was something specific like bind variables. If bind variables
were causing the problem, chances are the problem would have been
encountered before since this is old inherited code - hard-parsing or
not.
Received on Tue Oct 02 2007 - 00:33:51 CDT
