Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 18659 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 you can change a cross join into an inner join?
What is table value parameters (tvp)?
What is database black box testing?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
How to divide query output into multiple groups with the group by clause in ms sql server?
What is difference between foreign key and unique key?
Which autogrowth database setting is good?
What is buffer cash and log cache in sql server?
Explain user defined views?
What are the types of lock supported by ?
What is indexing explain it with an example?
What is a select query statement in ms sql server?
How data can be copied from one table to another table?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is the Disadvantage of indexed sequential file.
