Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 18653 Views
- Deutsche Telekom AG, I also Faced
- E-Mail Answers
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
Is it safe to delete log files?
What is not null constraint?
What do you mean by an execution plan? How would you view it?
What are the disadvantages of using querystrings to send data from one page to another?
What is a partitioned view?
Can you explain full-text query in sql server?
Can we delete data from a view?
Where do you find the default Index fill factor and how to change it?
Write the syntax for stuff function in an sql server?
define and explain the differences between clustered and non-clustered indexes.
What is row_number()?
What are the properties of sub-query?
How do you clear a log file?
what is an index? : Sql server database administration
How do indexes help, types?
