Sample SQL for Periodic Maintenance

This section provides additional details related to creating new partitions over time as well as archiving and restoring partitions. The To Do Entry, Inbound Sync Request and Initial Measurement Data maintenance objects are used as examples.

The section includes the following:

• Adding Partition

• Archiving Partition

• Archiving Subpartition

• Restoring Partition

• Restoring Subpartition

• Compressing Partition (D1_MSRMT table only)