• 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?