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 f...
Arshad440
Oct 26, 2023Brass Contributor
Use the Query In Profiler and Tuning advisor, From there you'll get some recommendations for Indexes and stats