Skip to main content
1 of 3
Kazi Lakit
  • 93
  • 1
  • 1
  • 4

Scan Count of a query increased to 2266 form scan count 1 after creating a non-cluster index. will it hamper my query performence?

On my query 1st time it was taking almost 39sec and showing me non-cluster index is missing and Scan count 1, logical reads 14553, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

After Creating the non-cluster index the duration of the query execution comes down to 1sec and it's showing Scan count 2266, logical reads 4539, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

logical reads is decreased after Creating the non-cluster index but Scan count increased to 2266 so my question is the performance of the query is developed or the Scan count 2266 make my query non-optimal?

Kazi Lakit
  • 93
  • 1
  • 1
  • 4