> Okay, now I need to do some homework. Are there resources > anywhere that can help tell me what queries would benefit > from such things? My knowledge of SQL is decent, but isn't > quite *that* deep. I would think all queries would benefit > from that.
Basically, if different inputs would cause significant differences in the optimal execution plan, cached execution plans aren't very helpful. In general, most queries benefit from using the same execution plan, which is why it's generally a good idea to just use cached execution plans without worrying about whether a specific query will perform better. This is an interesting document on plan compilation in SQL Server 2005: http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
