Home Forums SQL Server 2008 SQL Server 2008 - General deleting huge records From Table RE: deleting huge records From Table

  • November 21, 2010 at 11:58 pm

    #1253588

    Eralper (11/21/2010)

    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.

    Thanks for ur Quick Reply, The table does not have any relationship with other tables.

    as u said there is an index on the table, so i need to delete the index and recreate it back once the delete operation is done.

    what about log file? will it becomes huge in deleting these records?