• Another quick note - the dmv will only show an index if it has been used (read from or written to).

    So you may have an index that is truly not used at all - and it would not appear in the results.

    Although I guess if that were the case - the associated table wouldn't be being used 😛