SQL Administrator Question:
Download Questions PDF

Please explain 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 Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me why would you use SQL Agent?How to start SQL Server in different modes?