When do we use the UPDATE_STATISTICS command?

Question Posted / guest

4 Answers
18724 Views
Deutsche Telekom AG, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When do we use the UPDATE_STATISTICS command?..

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

When do we use the UPDATE_STATISTICS command?..

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

When do we use the UPDATE_STATISTICS command?..

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

When do we use the UPDATE_STATISTICS command?..

Answer / govind

its used to create auto indexes on table. means non
clustred indexes are created on table.which is used to
easily craeted data pages for modification and deleteion.

Is This Answer Correct ?

5 Yes

15 No

Post New Answer