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.

Copy 

sp_show_statistics_steps 'table_name' , 'index_name'

table_name

The name of the table that contains the index.

index_name

The name of the index on which you want statistics.

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.

The results returned indicate the selectivity of an index. A lower density indicates greater selectivity. The results provide the basis for determining whether an index is useful to the query optimizer.

The following example displays statistics information for the Employees_PK index of the Employees table.

Copy 
sp_show_statistics_steps 'Employees', 'Employees_PK'
Show: