SQL Database Concepts Question: Download Questions PDF
Tell me When is the UPDATE_STATISTICS command used?
![Basic SQL Server Interview Answer Basic SQL Server Interview Question](https://globalguideline.com/public/images/interview/6.png)
Answer:
- When the processing of large data is done, this command is used.
- Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. UPDATE_STATISTICS performs this job.
- Whenever large number of deletions, modification or copy takes place into the tables, the indexes need to be updated to take care of these changes. UPDATE_STATISTICS performs this job.
Download Basic SQL Server Interview Questions And Answers
PDF