Hi there, We are working on a medium size table which will have more than 100 million records. And the data will be loaded each hour with sql job and it will be constantly queried by reporting system. During the load about 10,00 rows will be deleted with each run and alot more will be inserted. Now, which way is better to go: 1. Delete the 1000 rows each hour? 2. Put a soft delete flag (basically and update statement) and then actually delete the records off peak hours? Please suggest! Thanks in advance!