Export (0) Print
Expand All

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.


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.

sp_show_statistics_steps 'Employees', 'Employees_PK'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft