Diagnosing excessive I/O Counts

There are several reasons why a query that performs large I/O might require more reads than you anticipate: