New answers tagged

2

Starting at the beginning: SQL Server uses statistics objects to generate cardinality estimates for the result set steps during the optimization phase. Cardinality estimates are used to generate a query plan, which is the logical plan by which SQL Server will physically access and retrieve the data in order to satisfy the request. Generally speaking, more ...


0

If you have AUTO_UPDATE_STATISTICS on, then yes, your statistics should update once 20% of the data has been modified. But, if you know it's this process that's throwing your statistics out of whack, you can also update them yourself after the process has run. https://msdn.microsoft.com/en-us/library/ms187348.aspx Call UPDATE STATISTICS on the affected ...



Top 50 recent answers are included