DB Options: Auto Create Incremental Statistics ON

In this video we cover the next database option which is AUTO CREATE INCREMENTAL STATISTICS. This option is useful when the database has partitioned tables. It allows the DBA to update stats by merging the updated stats for the partition in question with existing stats. In this way DBA are able to reduce the overhead of updating the stats on large tables. If not enabled an update to stats will require resampling on the entire table even if historical data has not changed. This results in wasted resources since we don’t gain any new info for old records that have not changed. Even if your database doesn’t contain partitioned tables it is advisable to enable this feature since it causes no harm when tables aren’t partitioned but provides benefits when tables are.

https://youtu.be/8yS24q-dFHo

Need more information? Visit https://www.enabledbusinesssolutions.com

 

To know more about Jayanth Kurup visit http://www.jayanthkurup.com

 

Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years’ experience. He has worked with companies like Microsoft, IBM, HCL, Wipro, WellsFargo, Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community. In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc

 

You can also reach Jayanth via his LinkedIn profile below www.linkedin.com/in/jayanth-kurup