• It depends. Compare the execution plans with and without date condition, you'll find out for sure.

    If unsure, you could also try the performance of the two, changing UPDATE to SELECT.

    If you could post tables and indexes script or attach the exec plan you would get better advice.

    -- Gianluca Sartori