The case of the Missing-Index-Not!

Question

I ran the code found here: SQLServerPedia Find Missing Indexes (sic) and it reported an index missing (one column in the equality column, none in the inequality column, and none in the included column).

However, this index already exists! I've updated stats on the index, on the table, dropped and recreated the index in question, run sp_recompile on the table. It still shows up in the list as MIA (and at the top of the list to boot)...

Any ideas on what to do from here? TIA for the help...

Answer 1

Try adding "DESC" to the index. And then restart the SQL instance to reset the informations

It worked before: Database Tuning Advisor recommends to create an existing index