January 14, 2005 at 12:40 pm
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
January 15, 2005 at 2:06 pm
The Index Tuning Wizard does an "OK" job of this, however I would recommend monitoring your SQL Server and looking at the batches with the highest number of "reads" and start looking at the code to see what is in the "WHERE" and in the "JOIN" columns and then cross-reference that with the indexes that are in place for the relevant tables involved.
-Max
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply