Forum Discussion
mancio35
Oct 22, 2023Copper Contributor
ghost index
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
- Arshad440Brass ContributorUse the Query In Profiler and Tuning advisor, From there you'll get some recommendations for Indexes and stats