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?
Does 1 = High desity and 0 = Low desity?
ASKER
Sometimes the column shows 1 or 0.
What does 0 mean?
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
http://msdn.microsoft.com/en-us/library/ms174384(v=SQL.90).aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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