October 28, 2009 at 11:01 am
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.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy