> Let's be clear here- a DBMS will cache ALL execution
> plans. The real question really is whether or not the cached
> plan will ever be used or
> if it will sit around and gather dust until it is evicted
> from cache.
> (Or worse yet, fill the cache up so other plans are
> evicted)
You are absolutely right. I was racing out the door when I wrote that. Looking
over it now, I realize I left out a very important phrase, which is
"effectively" cache. Totally different meaning. So thanks for the badly needed
clarification ;)
-Leigh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329568
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
