Optimize insert and delete Operation large indexed mssql table
Actually my problem is, I have table which is having 20 crore records,Every week i am going to delete around 50lac old records and inserting 40 to 50 new records into the table,then daily basis clients using my table extracting records based on some condition,

My requirement is how to optimize insert operation,Delete operation,and also select operation,
I created index also my table even though some of above operation taking to much time,

When insert,delete,select  records it took around 4 to 5 hours,  
Optimize insert and delete Operation large indexed mssql table
===

Actually my problem is, I have table which is having 20 crore records,Every week i am going to delete around 50lac old records and inserting 40 to 50 new records into the table,then daily basis clients using my table extracting records based on some condition,

My requirement is how to optimize insert operation,Delete operation,and also select operation,
I created index also my table even though some of above operation taking to much time,

When insert,delete,select  records it took around 4 to 5 hours,  