Diagnosing excessive I/O counts

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