SQL Insights

Lots of page reads correlate to slow queries

For SQL Server, the number of page reads correlates well with a query's performance, but lots of reads don't always mean a slow query. For example, if you have a table scan that reads 20 thousand pages, the query could still be relatively fast.

Will the query be faster with fewer reads? Probably, yes.