I am looking at some indexes and trying to figure out if they are actualy likly to be used by the optimizer. I have been using the DBCC SHOW_STATISTICS command and looking at the denistit which is usually a number like 3.3389768-6. I understand that the lower then umber the more likely the index is to be used but how should I read this number? In addition, what if the number is 0.0?
Any pointers would be appreciated