The stored procedure sp_show_statistics displays the current distribution statistics for the specified table and index, or for all tables and indexes.
The following table describes the columns returned in the result set.
The table that was specified.
The index that was specified.
The date and time when the statistics were last updated.
The number of rows in the table.
The number of rows that were used to calculate the statistics information.
The number of distribution steps.
The selectivity of the first index column prefix.
The average length of all index columns.
A Boolean value. True indicates that this statistic will be automatically updated the next time it is used, if it is determined to be stale.
A Boolean value. True indicates that the query optimizer has determined that this statistic must be updated. If RECOMPUTE is true, this statistic will be automatically recomputed the next time that the query processor uses this statistic.
The following example displays statistics information for all indexes on the Address table.