• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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?
0
Mr_Shaw
Asked:
Mr_Shaw
  • 2
1 Solution
 
Bhavesh ShahLead 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now