As per MSDN “Updating statistics ensures that queries compile with up-to-date statistics. SQL Server uses statistics to generate fastest query plan for any transaction so we should ensure all statistics must be up to date to get better query performance. Understanding Update Statistics in SQL Server Finally team has killed this transaction as advised by SAP support to improve the performance. This activity took very long time around 12 hours and never completed. This long running query was executing update statistics SQL Server operation on one of the biggest table in the database. DBAs were involved and identified a long running query that was causing the performance issue. Application team had reported performance issue while accessing one of the SAP system. Yesterday i had similar experience in one of our SAP system. It becomes more crucial if your database size is very very big or some critical business application is using this database. We should be very careful while running any of the database maintenance activities on production databases. Here, i will explain the best practices to run SQL Server update statistics on very large tables or databases.

This helps SQL Server query optimizer to generate optimum query plan and improve database performance as well.

Update Statistics in SQL Server is very important maintenance activity to keep database’s statistics up to date.

Update statistics sql server