question

dhewes avatar image
dhewes asked

Phantom index?

I ran a query that ran slow. I added the index and it ran fast. I added "with (index(0))" to remove the index. It ran fast. The plan did not show it was using the index when I used "with (index(0))". Thinking the index triggered a new plan, I deleted the index. It ran slow. Does this make sense?

performanceindexing
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jeff Moden avatar image Jeff Moden commented ·

Not without being able to see the execution plans.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.