Is there a way in which I can find out which sql execution/query plan uses which index?

Is there a way in which I can find out which sql execution/query plan uses which index?
Mr_ShawAsked:
Who is Participating?
 
Bhavesh ShahConnect With a Mentor Lead AnalysistCommented:
Hi,

In your SSMS toolbar, there is one option.
execution plan.
by enabling that you can checkout which index is used.

- Bhavesh
0
 
Bhavesh ShahLead AnalysistCommented:
fyi.


sample.JPG
0
 
Mr_ShawAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.