> Still, in that case, the DB will simply perform a recompile > to find a more suitable execution plan-- a step which would > have had been performed anyway had there not have been a > cached plan. So the worst case scenario seems to be you > would break even. Doesn't seem like you can go wrong with that.
Uh, no, the database will not simply perform a recompile unless there is no plan in the cache, or unless you explicitly tell it to recompile, or there's some other system flag that would force a recompile. The database can't know ahead of time whether there would be a more suitable plan without actually building that plan (which, of course, would defeat the purpose of caching the execution plan in the first place). 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
