When do we use the UPDATE_STATISTICS command?
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
What is the use of =,==,=== operators?
Explain linked server in sql?
What Is Rdbms?
What is merge join?
How to retrieve error messages using odbc_errormsg()?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How do you create an execution plan?
Explain transaction server auto commit?
Where actually sql azure database is hosted?
Why the trigger fires multiple times in single login?
Mention the different types of replication in sql server.
What is table level trigger?
What are xml indexes?
Explain difference between cross join and full outer join?
How to change parameter value inside the report?