• also be aware that using the output command to log/move the deleted data in a log or archive table, that this might affect performance (depending on how much records you process).

    Instead of 2 times the related index scans when performing first an insert into the log or archive table and afterwards the delete, the output clause has only 1 time the index scan, but performs a table spool that can cause even more IO.