Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning One interviewer asked me this following question RE: One interviewer asked me this following question
Steve-3_5_7_9
SSChampion
Points: 10832
More actions
October 27, 2010 at 7:03 am
#1242848
It's now using a bad query plan from the cache.
This exact scenario happened to us. As soon as the bad plan was removed; the sproc started running great again.