Apply table rotation

Preserve instance performance by applying table rotation.

Before you begin

Determine the type of table you have and whether you can apply table rotation yourself.

• You can apply table rotation to custom tables that begin with a u_ prefix at your own discretion.
• Do not apply table rotation to scoped tables that begin with an x_ prefix without consulting ServiceNow or the third-party plugin developer first.
• Do not apply table rotation to out-of-the-box tables that begin with a sys_ prefix. Contact Customer Service and Support for help with these tables.

Role required: admin

Procedure

1. Navigate to All > System Definition > Table Rotations.
2. Select New.
3. On the form, fill in the fields.

   Table 1. Table rotation group fields

   Field	Description
   Name	The name of the table.
   Type	The type of rotation. Rotation and Extension are time-based. Shard is based on a document ID. See Database rotation for more information.
   Rotations	The number of tables to maintain through the duration. Applies to Rotation type.
   Duration	The overall duration for the action. Applies to Rotation and Extension type.
   Clean base rotation	The date to clean (truncate) the base table. Applies to Rotation type.

4. Select Submit.
   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.