> 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:265304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4