set transaction isolation level read uncommitted

select DB_NAME(database_id) as DataBaseName
	  , count(*) as [Missing Index Count]
from sys.dm_db_missing_index_details
group by db_name(database_id)

order by [Missing Index Count] desc


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