Interested to Buy Any Domain ? << Click Here >> for more details...
When do we use the UPDATE_STATISTICS command?
- 4 Answers
- 18890 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 are the advantages of user-defined functions over stored procedures in sql server?
what are the important architecture components of SSRS?
What are the advantages of using third-party tools?
What are the requirements on sql server network connections?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
How to perform backup for certificates in sql server? : sql server security
Difference between LEN() and DATALENGTH() in sql server ?
What is table join?
Mention the command used to rename the database.
What is sub-query in sql server?
What are different types of data sources?
How to skip remaining statements in a loop block using continue statements?
How to define output parameters in stored procedures?
What is the sql case statement used for? Explain with an example?
What are the types of lock supported by ?
