You can use SQL Profiler to view execution plans. -----Original Message----- From: Richard Kroll [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 10:26 AM To: CF-Talk Subject: RE: cfqueryparam DECREASES performance?
> The SQL output by a query using cfqueryparam is a "prepared statement". > > He was suggesting that you compare the execution plan using cfqueryparam > vs. not using it to see what the difference is. Maybe I'm looking in the wrong place then. I know I can use MSSQL's SQL Management Studio to place in a SQL query and run it to view the execution plan. How can you run the queries in CF and see the execution plan from MSSQL? Rich Kroll ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4