Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Proc C Dynamic SQL - Parameterized SQL statements
Hello,
Is there any advantage in terms of speed, cache hits etc. if I use
the parameterized version of dynamic SQLs, ie., construct and pass in
values thru SQLDA instead of
building the values directly into the SQL string. To illustrate :-
Will the following statement be less efficient
"SELECT A,B FROM SOMETABLE WHERE A = 10" as oppossed to
"SELECT A,B FROM SOMETABLE WHERE A = : x "
and I pass in the value of x thru SQLDA.
The one benifit at my application level is that I can reuse the
SQLDA again and again. But I am wondering about any performance benefits
from the Oracle Server in
terms of improved cache hits or any other. I do not know much about
Oracle caching.
Thank you for your replies
Karthi
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Fri Jun 20 1997 - 00:00:00 CDT