SQL Server Database Administrator Question:

Download Job Interview Questions and Answers PDF

Why would you call Update Statistics?

SQL Server DB Administrator Interview Question
SQL Server DB Administrator Interview Question

Answer:

Update Statistics is used to force a recalculation of query optimization statistics for a table or indexed view. Query optimization statistics are automatically recomputed, but in some cases, a query may benefit from updating those statistics more frequently. Beware though that re-computing the query statistics causes queries to be recompiled. This may or may not negate all performance gains you might have achieved by calling update statistics. In fact, it could have a negative impact on performance depending on the characteristics of the system.

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
What is blocking and how would you troubleshoot it?What is database isolation in SQL Server?