Consider In-Database Archiving
Gh, April 20, 2018 - 7:00 am UTC
In-Database Archiving May ne relevant To this situation. Whether yes or not. I wouldn't go for such partitioning. Since have no ddl scripts I cant suggest a partitioning/indexing solution cause they are many and depends of ddl and the way you query.