Originally posted by fadace
Bad execution plan on the cache ?
bad execution plan regarding the input parameters ?
Difficult without comparing 2 showplan. Did zou execute a sp_showplan before dropping the SP ?
The only execution plan I had was form the actual delete statement that the stored procedure was running as opposed to the compiled stored procedure.
We had a thought on Friday that it may have something to do with the statistics on the table when the stored procedure was first created. There may have been a very small amount of data but had subsequently been loaded with a significantly larger amount.
Unfortunately (or fortunately in this case), it hasn't happened since, but if it does, I'll certainly check the stored procedure execution plan and post it in.