When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 17765 Views
- Deutsche Telekom AG, I also Faced
- E-Mail Answers
Answer Posted / guest
This command is basically used when we do a large processing
of data. If we do a large amount of deletions any
modification or Bulk Copy into the tables, we need to
basically update the indexes to take these changes into
account. UPDATE_STATISTICS updates the indexes on these
tables accordingly.
| Is This Answer Correct ? | 34 Yes | 6 No |
Post New Answer View All Answers
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is query processing?
what are constraints? Explain different types of constraints? : Sql server database administration
What is an execution plan? When would you use it?
What to perform pattern match with the like operator?
What is difference between equi join and inner join?
Do you know the isolation level that sql server support?
How do I start sql server 2016?
What is indexing in sql server with example?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is exclusive locks?
How to add more data to the testing table in ms sql server?
How you trouble shoot when any job fails
What is the use of keyword with encryption.
What is the concept of optimization?
