SQL Server Database Administrator Question:
Download Job Interview Questions and Answers PDF
Why would you call Update Statistics?
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 Question | Next Question |
What is blocking and how would you troubleshoot it? | What is database isolation in SQL Server? |