My table is huge and get lncremented to 10 - 20 GB in a week so we were planning to partition the table on date range weekly and push the the last old data to archive toother DB or tape.