Ravi Shekhar

Ravi Shekhar

  • 360
  • 4.5k
  • 2.1m

Take very much time at the time of deletion by query

Jul 10 2013 2:51 AM


Hi all,


I have a table which contain 60 colums and appropriate clustered and non clustered index and 50 lacs data. Now i want to move some useless data into any other table. when i insert in other table it takes 5 to 7 minuts per 10 lacs data. now when in delete this data from main table it takes around 40 or more than 40 minuts. Please advice me how to reduce this.
urgent for me. 

I am deleting data according to date means datewise.


Please help.


Answers (38)