O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Out-of-Date or Insufficient Statistics

Admittedly, having out-of-date or unavailable statistics is not as big a problem as it was in SQL Server releases prior to 7.0. Back in those days, the first question asked when someone was complaining of poor performance was, “When did you last update statistics?” If the answer was “Huh?” we usually found the culprit.

With the Auto-Update Statistics and Auto-Create Statistics features in SQL Server 2012, this problem is not as prevalent as it used to be. If a query detects that statistics are out of date or missing, it automatically causes them to be updated or created and then optimizes the query plan based on the new statistics.

Note

If statistics are missing or out of date, the first running query that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required