Link to home
Start Free TrialLog in
Avatar of Mr_Shaw
Mr_Shaw

asked on

DBCC SHOW STATISTICS

When I use DBCC SHOW_STATISTICS there is a column named Desity.

Does 1 = High desity and 0 = Low desity?
Avatar of Imran Javed Zia
Imran Javed Zia
Flag of Pakistan image

Hi,

Calculated as 1 / distinct values for all values in the first key column of the statistics object, excluding the histogram boundary values. This Density value is not used by the query optimizer and is displayed for backward compatibility with versions before SQL Server 2008

Please follow the link for more details:

http://msdn.microsoft.com/en-us/library/ms174384.aspx

Thanks
Avatar of Mr_Shaw
Mr_Shaw

ASKER

Sometimes the column shows 1 or 0.

What does 0 mean?
The results returned indicate the selectivity of an index (the lower the density returned, the more selective the index is) and provide the basis for determining whether an index is useful to the query optimizer. The results returned are based on distribution steps of the index.

http://msdn.microsoft.com/en-us/library/ms174384(v=SQL.90).aspx
ASKER CERTIFIED SOLUTION
Avatar of Imran Javed Zia
Imran Javed Zia
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial