사용하지 않는 인덱스 확인

-- 사용하지 않는 인덱스 확인

SELECT object_name(i.object_id) AS Table_Name, i.name AS Index_Name

FROM sys.indexes i, sys.objects o

WHERE i.index_id NOT IN

    (SELECT s.index_id

    FROM sys.dm_db_index_usage_stats s

    WHERE s.object_id = i.object_id

        AND i.index_id = s.index_id

        AND database_id = db_id('AdventureWorks'))

    AND o.type = 'U'

    AND o.object_id = i.object_id

ORDER BY object_name(i.object_id) ASC

GO