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?