Frequently insert/delete data from a table
518838Oct 9 2007 — edited Oct 9 2007Hi,
I've to design a database table which will have previous 2 months data at any time. For that, old data will be deleted and new data will be inserted to the table.
In this regard, below is my doubt regarding this:
If I'm inserting new data daily, the HWM will increase, & in case of delete, it won't get free. So at any time, I'm going for full table scan, it will be searching for more data blocks as compare to the existing data volume.
So in this case, what should be the approach for design?
Thanks
Deepak