sp_show_statistics_steps (SQL Server Compact)
The stored procedure sp_show_statistics_steps returns a histogram representing the current distribution statistics for the specified index in the specified table.
The following table describes the columns returned in the result set.
Column Name | Description |
---|---|
RANGE_HI_KEY |
The upper bound value of the histogram step. |
RANGE_ROWS |
The number of rows from the sample that fall within each histogram step, excluding the upper bound. |
EQ_ROWS |
The number of rows from the sample that are equal in value to the upper bound of the histogram step. |
DISTINCT_RANGE_ROWS |
The number of distinct values within a histogram step, excluding the upper bound. |
Show: