tags:

views:

29

answers:

1

If I run the execution plan of an sp, Management Studio suggests an index. I add the index, run the execution plan again, and it keeps suggesting the same index... What am I doing wrong here? I already restarted SqlServer and Management Studio, but that's doesn't help.

+1  A: 

Index column order and sort order?

See this please: Database Tuning Advisor recommends to create an existing index

gbn