I'm confused by the results that I'm getting from sys.dm_db_missing_index_stats ...
The following query returns missing indexes that are actually created on the tables.
select * from sys.dm_db_missing_index_details where database_id = DB_ID('DatabaseName');
Has anyone else seen this issue??
Also, I noticed that the duplicate indexes that exist on the database are showing 0 for usage stats.
Any help would be greatly appreciated.