Updating a table in sql server 2016

SQL Server 2016 builds upon that work with the promise of even more accurate estimates when you set the compatibility level to 130.

This usually isn’t a problem during upgrades, as the database was designed with the older feature set in mind.Cardinality Estimator At the core of any query optimizer is the cardinality estimator.This looks at the statistics on the tables being queried and the operations being performed to estimate the number of rows for each step in the query’s execution plan.Starting with SQL Server 2016 (compatibility level 130), this threshold is related to the number of rows in a table – the higher the number of rows in a table, the lower the threshold will become to trigger an update of the statistics.Note that this behavior was available under Trace Flag 2371 in previous releases.

Leave a Reply