• Hey Grant,

    You might well be right - the first query does do more logical IO, but that's not the whole story. If the whole table is scanned in allocation order it might be more efficient in practice - might. The other thing is CPU. 2005 often made a bit of a mess of queries against a single partition - especially if the tables were large enough to warrant an parallel plan (one thread per partition), or if a constant scan with a loop join to a lookup or whatever was executed many times. It's impossible to know for sure which is the 'better query' just from looking at the SQL.

    As an aside, the addiction to measuring logical IO alone that some have is a bit one-dimensional. See Joe Chang's excellent blogs on CPU usage and table scanning at . Makes you think!

    Cheers,

    /Paul