• I believe the difference here is in the hash match operation , in your version it is matching on 2 columns and in Jeff's 1 column.

    Hash matching is a comparatively expensive operation and the pure number of scalar operations executed is a bit of a red herring.

    -- Though Paul has done much better explanation 😉



    Clear Sky SQL
    My Blog[/url]