Indexes não utilizados

IndexesNaoUtilizados.sql

select 
db_name() as DataBaseName
,SCHEMA_NAME(O.schema_id) as SchemaNAme
,OBJECT_NAME(I.object_id) as TableName 
,I.Name as IndexName
from sys.indexes I 
inner join sys.objects O on I.object_id = O.object_id
left outer join sys.dm_db_index_usage_stats S on S.object_id = I.object_id
											and I.index_id = S.index_id and database_id = DB_ID()
where OBJECTPROPERTY(o.object_id,'IsMsShipped') = 0
and i.name  is not null
and s.object_id is null