DBCC SHOW_STATISTICS returns info about 3 components:
- density vector
- histogram = is a statistical construct that shows how often data falls into varying categories. The histogram stored by SQL Server consists of a sampling of data distribution for a column or an index key of up to 200 rows.
DBCC SHOW_STATISTICS('<tablename>', '<indexname>');
You can limit the statistics information displayed by using
WITH HISTOGRAM clause:
DBCC SHOW_STATISTICS('<tablename>', '<indexname>')