Thread: enormous delete

  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Stratford upon Avon
    Rep Power

    Unhappy enormous delete

    I executing a batch query to do a delete going on a table which contains over 16 million rows. The delete has been running for more than 24hours and is not finished. If I stop the delete now will it roll everything back? Or will the rows deleted remain deleted?
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Outside US
    Rep Power
    I don't know if you'll get your data back, but it's possible, it should keep a transaction log.
    If you just wanted to empty that table you should have used Truncate or a drop -> create, way much faster.
    See the docs:

    Removes all rows from a table without logging the individual row deletes.
    TRUNCATE TABLE is functionally identical to DELETE statement with no WHERE clause: both remove all rows in the table. But TRUNCATE TABLE is faster and uses fewer system and transaction log resources than DELETE.
    Last edited by pabloj; November 16th, 2003 at 04:41 AM.

IMN logo majestic logo threadwatch logo seochat tools logo