ghost index

[mancio35]

Hi,

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?

Thanks

Andrea

[#2]

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