You can apply a table rotation to preserve instance performance.

Before you begin

Role required: admin

Procedure

  1. Navigate to All > System Definition > Table Rotations.
  2. Click New, or select the table rotation group to modify.
  3. Fill in the fields:
    Table 1. Table rotation group fields
    FieldDescription
    Name Enter the name of the table.
    Type Choose Rotation, Extension, or Shard. Rotation and Extension are time-based, Shard is based on a document ID. See Database rotation for more information.
    Rotations Sets the number of tables to maintain through the duration.

    Applies to Rotation type.
    Duration Set the overall duration for the action.

    Applies to Rotation and Extension type.
    Clean base rotation Sets the date to clean (truncate) the base table.

    Applies to Rotation type.
  4. Click Submit or Update.
    Note: Deleting a rotation deletes the additional tables and all the data. Do not delete the rotation if you still need the data.

    When you define a new rotation, a schedule creates and new data writes to one of the tables in the rotation group. The group includes the original table plus several additional tables.

    New table rotation group