Skip to main content
Database Administrators

Return to Question

added 7 characters in body; edited title
Source Link
Martin Smith
Martin Smith
  • 88.7k
  • 15
  • 262
  • 366

Scan Count of a query increased to 2266 form scan countfrom 1 to 2,226 after creating a non-clusterclustered index

On my query 1st time it was taking almost 39sec39 seconds and showing me non-clusterclustered 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-clusterclustered 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 indexcreating the non-clustered index, but Scan count increased to 2266Scan 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?

Scan Count of a query increased to 2266 form scan count 1 after creating a non-cluster index

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?

Scan Count of a query increased from 1 to 2,226 after creating a non-clustered index

On my query 1st time it was taking almost 39 seconds and showing me non-clustered 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-clustered 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-clustered 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?

Tweeted twitter.com/StackDBAs/status/675741113366482948
format
Source Link
user507
user507

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.

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.

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

logicalLogical reads is decreased after Creating the non-cluster indexcreating the non-cluster index, but Scan count increased to 2266 soScan 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?

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?

Scan Count of a query increased to 2266 form scan count 1 after creating a non-cluster index

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?

Source Link
Kazi Lakit
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?