Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 19043 Views
- Deutsche Telekom AG, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you create an execution plan?
Explain cursor as data base object?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the steps to insert a table?
How you can get a list of all the table constraints in a database?
What is normalization and denormalization in sql server?
What is store procedure? How do they work? When do you use?
What is meant by dirty read?
Tell me when is the update_statistics command used?
Write a SQL query in order to merge two different columns into single column?
Do you know what are the ways available in sql server to execute sql statements?
What is proper subset of candidate key?
What is SQL Azure?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What are triggers in ms sql server?
