1
kudos
spam Kudos Remove

Lies damned lies and statistics - Part II

published 1008 days, 20 hours, 39 minutes ago posted by sasa 1015 days, 18 hours, 10 minutes ago
Monday, August 17, 2009 1:25:13 PM GMT Monday, August 10, 2009 3:53:59 PM GMT

In previous post I listed situations where your statistics might need some special attention (http://sqlblog.com/blogs/elisabeth_redei/archive/2009/03/01/lies-damned-lies-and-statistics-part-i.aspx). As I mentioned in that post, the symptoms are typically related to more or less random variations in duration that cannot be explained by resource contention or blocking. A quick recap of the various problems you can encounter: 1. Statistics is out-of-date 2. T...

category: Management | clicked: 1 | | source: sqlblog.com | show counter code
tags: Actual Rows, Estimated Rows, histogram, Skewed Data, statistics

No comments yet, be the first one to post comment.

To post your comment please login or signup