Yes.
The first query uses bind variables to pass the value, while the second uses
a literal.
>From a performance standpoint, bind variables are preferable, since Oracle
can cache the execution plan for the query, whereas when passing a literal
value, each time the query is made a new execution pla
k Inc.
www.icglink.com
-Original Message-
From: Dave Hatz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 03, 2007 2:20 PM
To: CF-Talk
Subject: Binding Oracle query params
I am curious if someone could tell me the difference between these 2 queries
from a performance standpoint. We are using CF7
> I am curious if someone could tell me the difference between
> these 2 queries from a performance standpoint. We are using
> CF7 with Oracle 9i.
>
> SELECT First, Last FROM Customers WHERE ID= cfsqltype="cf_sql_varchar" value="#ID#">
>
> vs.
>
> SELECT First, Last FROM Customers WHERE ID
I am curious if someone could tell me the difference between these 2 queries
from a performance standpoint. We are using CF7 with Oracle 9i.
SELECT First, Last FROM Customers WHERE ID=
vs.
SELECT First, Last FROM Customers WHERE ID='1234'
Is there a performance difference between these 2
4 matches
Mail list logo