Optimizing ColdFusion Queries by Reordering SQL Clauses
Complex or multiple ColdFusion queries can create slow performance on a page. In such cases, you may be able to improve performance by reordering SQL clauses in the cfquery statement. This article gives you some interesting tips on how to speed things up.
Optimizing ColdFusion Queries by Reordering SQL Clauses