When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 17795 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 to write an inner join with the where clause in ms sql server?
Explain collation?
What is set nocount on?
Write a code to select distinct records without using the DISTINCT keyword.
Do you know what are the properties of the relational tables?
Explain the steps to use transact-sql cursor?
What is scrollable cursor?
What is mapping schema?
How can i Relate Tables in SSIS
What is identity?
Can we use where clause in union?
Explain Capacity planning to create a database? and how to monitor it?
what is difference between view and Dip.
What is the openxml statement in sql server?
How to drop an existing table?
