SQL Database Concepts Question:
Download Questions PDF

Tell me When is the UPDATE_STATISTICS command used?

Basic SQL Server Interview Question
Basic SQL Server Interview Question

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.

Download Basic SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what do you mean by an execution plan? Why is it used? How would you view it?Tell me what do you understand by a view? What does the WITH CHECK OPTION clause for a view do?