I have a procedure that queries a table. This should be fast because of an index, but some index bloat has caused the
indexto become expensive, and so the procedure has cached a plan that uses a full table scan. I've since fixed the
indexbloat, but the procedure still seems to be doing full table scans. Is there a non-disruptive way to invalidate the
cachedplan for that procedure globally?