var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Selection of Index by Stored procedure
Noticed that one of my stored procedures was running slowly.
So i looked the the explain plan and noticed that it was using a different
index to what it did when i created it a month or so ago.
So i dropped and recreated the stored procedure and it started using
the index it was supposed to, and was running much faster.
My question is, why did it start using another index for no appartent reason and is there an easy way i can check the rest of my stored procedures to make sure the same isn't happening to them..
If at the very beginning, when you created the stored procedure, it was using the correct index, then I would say that only the "with recompile" clause could have changed the query plan (if you haven't dropped the sp in the meantime).