sys.dm_db_missing_index_stats reports existing index

Question

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.

score 2 · Accepted Answer · answered Jan 24 '11 at 17:45

2

answered Jan 24 '11 at 17:45

NicCain

score 0 · Answer 2 · answered Jan 24 '11 at 17:24

0

Have you validated that the existing indexes are identical in every aspect with the recommendation, and they are enabled?

answered Jan 24 '11 at 17:24

Remus Rusanu

2 Answers2