• If you have enterprise edition maybe partitioning the table will work for you, else you probably want to go with a crawler delete to avoid blowing the log and reduce contention.

    If you are deleting the majority of the table could be faster to insert data you want to keep into another table, drop original, then rename new table.

    We really need to know the table schema, a bit of example data and the criteria you wish to delete by.

    ---------------------------------------------------------------------