When do we use the UPDATE_STATISTICS command?
Answer Posted / nscom
There are three scenarios where you need to fire the update
statistics
1. Query execution times are slow.
2. Insert Operations Occur on Ascending or Descending Key
Columns
3. After Maintenance Operations - Operations that change the
*distribution of data" such as truncating a table or
performing a bulk insert of a large percentage of the rows.
More information is here
http://msdn.microsoft.com/en-us/library/ms190397.aspx#UpdateStatistics
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to use DTS package in 2000,2005,2008 in sql server
How to resolve the orphan use problem? : sql server security
What are the grouping functions?
Explain about integration services of Microsoft SQL server?
What is dml command?
How you can get the list of largest tables in a database?
Introduction of rollup clause using sum and group by clause?
What is the difference between for trigger and after trigger?
What is a data source or ds? : sql server analysis services, ssas
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
Can we use custom code in ssrs?
What is tcl in sql server?
What is NOT NULL Constraint in sql server 2012?
How you trouble shoot when any job fails
How to find the service pack installed? : sql server database administration