• Physical reads.

    Your data is not in memory so it has to go to disk.

    This is even worse if it has to do an index seek or scan and then has to do lookups cos then those will be random physical reads.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]