Truncate table updating statistics
You must then rebuild the entire index or, for a global index, each of its partitions.The database lets you override this default behavior if you specify statement for the maintenance operation.but if you are fine with your sql server performance and Query execution times.then i suggest stopping the Updates Statistics command from your Maintenance Plans updating statistics is important and useful 1. We've restricted the ability to create new threads on these forums.
We've got lots of great SQL Server experts to answer whatever question you can come up with. Hi, can anyone tell me what actually happen with statistics after a table is truncated.The statistics auto update is triggered by query optimization or by execution of a compiled plan, and it involves only a subset of the columns referred to in the query.Statistics are updated before query compilation if AUTO_UPDATE_STATISTCS_ASYNC is OFF here are nice articles that speak about when update statistics is triggered in SQL server after knowing when statistics is triggered it will help you decide when to update statistics manually to know more about Statistics & its effect on performance i recommend Brent Ozar and Kimberly in sqlskills very good blogs & bloggers. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).If you are using Auto Update Statistics for your database, see this reference for the threshold of when statistics are updated. if and only if auto update statistics feature is not good enough for your requirements.
i mean if auto create and auto update statistics are ON and you are getting a bad query plan because the statistics are not accurate or current then it might be a good idea to have control over statistics creation and update.allows the SQL Server query optimizer to produce good query plans consistently, while keeping development and administration costs low 2.