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.
Ben >> Am I going to see a significant performance increase? For >> the sake of argument, pretend that sample query I included in >> my first post is heavily hit. I'm running SQL Server 2000 >> (soon to upgrade to 2005). > >The answer will depend on whether that particular query benefits from a >generic, reusable execution plan. > >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285974 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
