SQL Server Performance Tuning - DBCC SHOW_STATISTICS command

This describes the usage of DBCC SHOW_STATISTICS command which is used for performance tuning in the Sql Server.

DBCC SHOW_STATISTICS command is used to fetch optimization statistics of a table or indexed view. This command displays the header, histogram and density vector based on the data stored in the statistics object, where statistics object is the one created on either an index or a list of columns of the table. Statistics object contains a header (which contains metadata about statistics), a histogram (which contains distribution values of the first key column of the statistics object, density vector (which is used to measure cross column correlation.

Syntax: DBCC SHOW_STATISTICS (TABLE ,TARGET )

Here, TABLE is the table name or indexed view to which the statistics information needs to be displayed.
           TARGET is the name of either Index or Statistics or column to which statistics information needs to be displayed.

Ex: DBCC SHOW_STATISTICS (‘Table1’, AK_Table1);