# Find unused indexes
SELECT
		OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],
         I.[NAME] AS [INDEX NAME],
		     s.last_user_seek,
		     s.last_user_scan,
		     s.last_user_lookup,
         USER_SEEKS,
         USER_SCANS,
         USER_LOOKUPS,
         USER_UPDATES
FROM     SYS.DM_DB_INDEX_USAGE_STATS AS S
         INNER JOIN SYS.INDEXES AS I
           ON I.[OBJECT_ID] = S.[OBJECT_ID]
              AND I.INDEX_ID = S.INDEX_ID
WHERE    OBJECT_NAME(S.[OBJECT_ID]) ='TABLE_NAME'
order by last_user_seek


#