After adding index Execution Plan SqlServer keeps suggesting the index

Question

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.

score 1 · Accepted Answer · edited May 23 '17 at 10:24

1

Index column order and sort order?

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

edited May 23 '17 at 10:24

Community

1
1

answered Mar 14 '10 at 15:25

gbn

422,506
82
585
676

After adding index Execution Plan SqlServer keeps suggesting the index

1 Answers1

Linked