CFQUERYPARAM and Oracle Databases
Bantu.com has done extensive work with CFQUERYPARAM with Oracle databases, and they note a major performance improvement of between 100 and 1000 percent, depending on the page, on the database side. CFQUERYPARAM allows you to bind variables to a specific variable type in a database engine. In this article, the Chief Information Technology Officer at Bantu.com explains how CFQUERYPARAM works and how to use them effectively.
CFQUERYPARAM and Oracle Databases