Thanks for the feedback,
Yes the DB contains large data sets spanning years and need to retain the data so that we can build up Summarized Report based on it.
Table contains upto 297847 records on weekly basis,so may be at certain point it wud be impossible to store data due to data storage...