Mark Salvador (2/5/2009)

---

When I left join them like this:

select *

from sys.dm_db_missing_index_group_stats AS migs

left JOIN sys.dm_db_missing_index_groups AS mig ON migs.group_handle = mig.index_group_handle

left JOIN sys.dm_db_missing_index_details AS mid ON mig.index_handle = mid.index_handle

I got data coming from dm_db_missing_index_group_stats but got NULL result in sys.dm_db_missing_index_groups and sys.dm_db_missing_index_details.

I have result though when I make a join between sys.dm_db_missing_index_groups and sys.dm_db_missing_index_details.

I am suspecting that dm_db_missing_index_group_stats could be corrupted or something.