• Well, I agree with the others to first look at your index. If the index is still there then start with performance monitor to look at the processor counter, batch requests/sec, etc. It may also because the heavier traffic during that day. Another cause is the table may grow larger than before. Or the cache is emptied that makes compiling also possible. Check with the execution plan as well.

    Ivan Budiono