Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about using bind variables in static sql
Yes.
Improves performance and scalability. That is the way the shared pool is intended to work.
Daniel Morgan
Ryan Gaffuri wrote:
> I know this improves performance in dynamic sql. Does it improve performance
> in standard sql? When would you want to use a bind variable in static sql?
> How does the way Oracle handles a bind variable in standard sql differ from
> how it handles a & variable?
>
> Thanks
Received on Thu Mar 14 2002 - 00:09:54 CST