SQL Server Database Administrator Question:

Why would you call Update Statistics?

Tweet Share WhatsApp

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 PDF Read All 84 SQL Server DB Administrator Questions
Previous QuestionNext Question
What is blocking and how would you troubleshoot it?What is database isolation in SQL Server?