Índices innecesarios en una base de datos/ Índices que no se utilizan en una base de datos - SQL Server

DECLARE @db VARCHAR(25)

SET @db = '<database>'

SELECT object_name(i.object_id), i.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(@db) )

AND o.TYPE = 'U'

AND o.object_id = i.object_id

ORDER BY object_name(i.object_id) ASC

GO