SQL Administrator Question:

Please explain 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 Administrator PDF Read All 84 SQL Administrator Questions
Previous QuestionNext Question
Tell me why would you use SQL Agent?How to start SQL Server in different modes?