All you need to do is to find the middle ground between the time it takes to recompile queries and improving query plans. Below we are going to show how to update statistics for an index, table and how to update all statistics. If you care about SQL Server performance you need to take SQL Server Statistics into account. Statistics are lightweight and small objects which describe how data in SQL Server tables are distributed. Question: You talked about when statistics get updated last week. How can I see when the statistics were last updated? In following statement, I have specified an additional option of FULLSCAN, which implies that the complete table is scanned to update the statistics.
|