Post reply

Deleting data from Table taking very long time

  • February 19, 2009 at 9:31 am

    #72682

    Hi all,

    I have a procedure (MS SQL Server 2000) which has to insert into a table in different database and then will delete those data from the related tables. There are more than 6 tables.. with primary key and foreign keys.. But I have one table which is giving the procedure a lot of problem.

    I have attached the ExecutionPlan for the same.

    The delete from other table with more records than it takes less time but this take more than the others..

    Any suggestions ..

    Table Tx1 has total rows of 56848137

    It has a joint primary key in 7 columns.

    It has the clustered index.

    I have another table Tx2 which has 56848332

    it also has the same configuration.

    When I delete the Tx2 table with the conditions deletes 6 rows in 2 secs.

    but when I try to delete the Tx1 it takes nearly 10 mins..

    I have done reindexing also .. but no changes..

    Thanks,

    Harsha

  • February 19, 2009 at 11:31 am

    #946953

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic660511-8-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply