foxxo (1/16/2013)
It wasn't the statistics that fixed the issue, it was the query being recompiled (ie. new plan).From BOL:
http://msdn.microsoft.com/en-us/library/ms187348.aspx
Updating statistics ensures that queries compile with up-to-date statistics. However, updating statistics causes queries to recompile. We recommend not updating statistics too frequently because there is a performance tradeoff between improving query plans and the time it takes to recompile queries.
rebuilding an index automatically rebuilds the statistics on that index
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato