• ananda.murugesan (3/6/2014)


    Hi,

    I checked unused index, As per that script result return value only two column in NONCLUSTERED

    total 4 NONCLUSTERED index values as below and Remaining all the column values are 0 (Zero),

    user_updates = 36361 - it is used for UPDATE SQL statement, so this is not unused index.

    system_scans = 12

    total 23 UNIQUE CLUSTERED index values apperad in system_scans column and Remaining all the column values are 0 (Zero), so will it be unused index?

    The user_updates column means the number of times a user action caused a modification of the index, not how many times the index was used to satisfy an update query. If there are more user updates by a significant amount than there are user seeks then the resources used to maintain the index structure may be greater than the benefit the index provides. Glenn Berry, Jason State, and Kendra Little all have scripts on their blogs that do a pretty good job of identifying indexes that may be candidates for dropping or modification.