Export (0) Print
Expand All

sp_show_statistics_steps (SQL Server Compact Edition)

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 AK_Product_Name index of the Address table.

sp_show_statistics_steps 'Address', 'AK_Product_Name'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft