10774 - read-ahead reads 567

Hi experts

what's the mean: read-ahead reads 567

this completes statistics io:
(1 row(s) affected)
Table 'Contact'. Scan count 1, logical reads 569, physical reads 1, read-ahead reads 567, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
enrique_aeoAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It's a performance strategy made by SQL Server engine. I think he predicts that the query will need to read those rows so it do it in advance.
The MSDN article can explain it better than me :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.