I don't think using a join would impact greatly (if at all) on the performance of your delete operation. Check the estimated execution plans for the subquery or join. You might be surprised to find that they are not very different. After the temporary change to a simple recovery model, It would help...