We help IT Professionals succeed at work.

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.
Comment
Watch Question

IT Engineer
Distinguished Expert 2017
Commented:
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 :)