ghost index

Copper Contributor


I'm trying to optimize a query.
Looking at the execution plan, I find that it suggests creating an index using 3 columns.
Once the index was created, I rechecked the execution plan and again found the indication to create the same index even though I had already created it.

it's as if he doesn't see it
How is it possible?




1 Reply
Use the Query In Profiler and Tuning advisor, From there you'll get some recommendations for Indexes and stats