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
What are data regions?
What is log in sql server?
Can you move the resources after pausing the node? : sql server database administration
What is the main purpose of having conversation group?
query processing
What is database replication? What are the different types of replication you can set up in sql server?
What function does a database engine serve in the sql server?
What is store procedure? How do they work? When do you use?
What is difference between join and natural join?
what is raid and what are different types of raid configurations? : Sql server database administration
What is the recovery model?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What are tables in sql server?
Tell me what are the essential components of sql server service broker?
What is data source in connection string?