The Statistics Histogram
Up to 200 sample values can be stored in the statistics histogram. Each sample value is called a step. The sample value stored in each step in the RANGE_HI_KEY column is the endpoint of a range of values. Four values are stored for each step:
RANGE_ROWS—This indicates how many other rows are inside the range between the current step and the step prior, not including the step values themselves.
EQ_ROWS—This is the number of rows that have the same value as the sample value. In other words, it is the number of duplicate values ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
