I've read in several articles that the density of a column is (1.0 / count(distinct columnname)). I have a column with roughly 2.6 million distinct values over 2.7 million rows, but the column density in DBCC show_statistics even AFTER updating statistics with fullscan is .48.
I am confused as to where this number could be coming from. Can anyone explain it to me?
STAT_HEADER? BOL Says this isn't used anyway