Have an index on a table that keeps appearing in the sys.dm_db_missing_index_details DMV. The index already exists. In fact when I drop and recreate the index it falls out of the DMV however within 24 hours or so it reappears. Missing/Corrupted stats? any other ideas?
Thanks.