When do we use the UPDATE_STATISTICS command?
Answers were Sorted based on User's Feedback
Answer / guest
This command is basically used when we do a large processing
of data. If we do a large amount of deletions any
modification or Bulk Copy into the tables, we need to
basically update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.
Is This Answer Correct ? | 34 Yes | 6 No |
Answer / sivakumar
That command is used to rebuild indexes on tables, which
can speed up queries. You might want want to do it whenever
a large amount of data has been deleted or added. It can be
complicated to determine whether it is more efficient to do
this, or to just let the statistics rebuild automatically
so, as usual, testing is called for in each individual case
to get optimal performance.
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
What method is used by the Command classes to execute SQL statements that return single values?
How can delete duplicate records in cte in sql server?
Explain atomicity?
Explain what is the main purpose of having conversation group?
What is multilevel indexing?
What is unpivot?
What is sql server replication? : sql server replication
How would you Update the rows which are divisible by 10, given a set of numbers in column?
what are user defined datatypes and when you should go for them? : Sql server database administration
write query for fourth maximum salary from employee table
14 Answers Mind Tree, SP Software,
How to delete all rows with truncate table statement in ms sql server?
What is use of except clause?