Table cleaner

Prevent tables from growing to an unmanageable size by deleting records automatically.

Key benefits

• Improve query performance by deleting records you no longer need.
• Delete older, expired, or unwanted records from tables automatically.
• Prevent data from growing exponentially.

Accessing table cleaner rules

You can define and access table cleanup rules for a table by navigating to All > System Data Management > Data Management Policies and selecting the data management policy for the table.

Use cases

• Delete closed incidents that haven't been updated in 30 days. In this scenario, you define a table cleanup rule on the Incident [incident] table using sys_updated_on as the match field and you specify 2,592,000 as the age in seconds. You specify the condition State is Closed to only delete closed incidents.
• Manage data growth in tables used by Virtual Agent and Conversational Interfaces by activating table cleanup rules for the following tables:
  • Chat Server [sys_cs_analytics]
  • Conversations [sys_cs_conversation]
  • Message Last Reads [sys_cs_message_last_read]
  • Ci Analytics [sys_ci_analytics]
• Conversation-related tables can increase in size and end up affecting system performance. Limit data growth by cleaning records in tables related to Advanced Work Assignment. See .

For information on using table cleaner, see Deleting older or unwanted records.