dbcc show_statistics output
The dbcc show_statistics command displays three different sets of information.
statistics for INDEX 'OrderID'.
Updated Rows Rows Sampled Steps Density Average key length
-------------------- ----- ------------ ------ -------------- ------------------
Oct 2 1999 6:44PM 2155 2155 270 1.1922787E-3 7.9999347
(1 row(s) affected)
- Updated is the date and time the statistics were last updated.
- Rows is the number of rows in the table.
- Rows Sampled is the number of rows used to generate the statistics information.
- Steps is the number of distribution steps.
- Density is the selectivity of the index.
- Average key length is the average length of a row.
All density Columns
------------------------ ----------------------------------------
1.2048193E-3 OrderID
4.6403712E-4 OrderID, ProductID
(2 row(s) affected)
- All density is the selectivity of the specified order column list in the index.
- Columns is the list of the index columns for which all the density is displayed.
Steps
-----------
10248
10251
10253
10256
10259
10262
10264
10857
10860
10863
10866
10869
10872
10954
(270 row(s) affected)
- Steps is the values in the current distribution statistics for the specified index or statistics group on the specified table.