Post reply

Index Usege Report

  • April 6, 2006 at 1:03 pm

    #152893

    Used Index Tuning Wizard to find indexes that are not in use currently (made 4 runs by 30 minutes each). Two indexes (from total 6) are recommended to drop but one- not regardless that Percent Usage=0 every time. Why is this? How Wizard select victim, i.e. index to drop? Thanks

  • April 6, 2006 at 1:21 pm

    #631338

    I think probably you have statistics for same column and wizard makes safer suggestion  with interpretation that in absence of stat this index can be useful.

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply