• If you have foreign keys, constraints etc it will take a longer time to delete records from sql table.

    Also it will be better I guess to disable indexes (delete indexes) and then after deletion of unwanted rows recreate the indexes again. This will save server to update the indexes after every DML operation on the table.