Hiesh Kidecha

Hiesh Kidecha

  • NA
  • 241
  • 3.5k

How to convert index from scan to seek?

Apr 18 2021 6:46 AM
I have a sql query which contains multiple table joins. Already created non clustered indexes. I have optimized the query as much as possible based on looking at SQL quey execution plan. I found some of the indexes being scanned. My question is how exactly i convert index scan to index seek?? What exact parameters needs to be consider for this?

Answers (3)