Answer Posted / rajesh ranjan
Hi
This command is basically used when a large processing of
data has occurred. If a large amount of deletions any
modification or Bulk Copy into the tables has occurred, it
has to update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Who developed sql server?
What are different types of statement?
How do you delete duplicate rows in sql server?
How to write a query with an inner join in ms sql server?
Can you type more than one query in the query editor screen at the same time?
What are the methods used to protect against sql injection attack?
Explain about analysis services?
What are indexes in ms sql server?
What is the need for group functions in sql?
How do I install sql server?
Difference between 2NF &3NF ?
What are the 7 disadvantages to a manual system?
what's the difference between a primary key and a unique key? : Sql server database administration
Is foreign key unique?
What is transaction server distributed transaction?