• There's something I'm a bit confused about here...

    It's the following:

    AVG_RANGE_ROWS: 176.7533 -- number of records for each distinct value (those within the DISTINCT_RANGE_ROWS)

    Now how can you have a part of a row? Surely the number of rows for each distinct value whole come out to be a whole number? This seems, as the name suggests, an average.

    And in fact... I just checked this out and this is what Microsoft have to say about this:

    AVG_RANGE_ROWS - "Average number of rows with duplicate column values within a histogram step, excluding the upper bound (RANGE_ROWS / DISTINCT_RANGE_ROWS for DISTINCT_RANGE_ROWS > 0)."

    Random Technical Stuff[/url]