Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Nit-picking on range descriptions Expand / Collapse
Author
Message
Posted Wednesday, October 28, 2009 11:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 22, 2014 12:12 PM
Points: 86, Visits: 142
The article has the descriptions
RANGE_HI_KEY: Starting boundary for the step.
RANGE_ROWS: How many rows in the base table fall between this Range_HI_KEY and the next (not including either).
...
DISTINCT_RANGE_ROWS: How many distinct values between, but not including this RANGE_HI_KEY and the next.

Actually, the RANGE_HI_KEY is the upper-most key for each step, not a starting boundary. And the range is all the values less than the range key and greater than the previous range key (if it exists, it might be the first range.) See BooksOnLine.

Apart from that, great article.
Post #810147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse