My takeaway from the meeting was the fact that make the solution from acceptable to perfect may not be necessary and could cost a lot. In particular it may be enough to use partitioning option just to avoid long running delete statements on non partitioning table. Create as select may be acceptable option as opposite to exchange partition functionality. Or even further. We can keep a full backup and if necessary extract the data from the full backup. The main value of partition it helps to resource expensive delete operation.
0 · November 28