Updating sql server 2016 r2
19-Nov-2019 13:45
You can find additional details about this option in this tip.
In certain rare cases you might have to disable this useful feature.
It is recommended to update your statistics after you insert a larger amount of data into ascending or descending key columns because in such cases the statistics histogram might not have any information about the newly inserted values.
The statistical histograms are used by the Query Optimizer to choose the optimal query execution plan.The name of the auto-created statistics includes the column name and the object ID in hexadecimal format: _WA_Sys_.These statistics are used by the Query Optimizer to determine the optimal Query Execution Plan.Another reason for creating statistics is that you can see missing statistics warnings (a yellow triangle with a black exclamation point or red table name in SQL Server 2000) on the Graphical Query Execution Plan as shown in the screenshot below.
You can use SQL Server Profiler to monitor the Missing Column Statistics event class.
When you set this option to OFF, the Query Optimizer will update the outdated statistics before compiling the query.