CODEWITHSUNDEEP
sql-server
Lieven Cardoen
Lieven Cardoen

Reputation: 25959

After adding index Execution Plan SqlServer keeps suggesting the index

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.

Upvotes: 3

Views: 1725

Answers (1)

gbn
gbn

Reputation: 432311

Index column order and sort order?

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

Upvotes: 1

Related Questions