Archive data The archive application moves data that is no longer necessary for immediate day-to-day access from primary tables into a set of archive tables. The longer an instance runs, the more likely it is to accumulate data that is no longer relevant to current business needs. For example, task records from two years ago are typically less relevant than currently active tasks. Old data may eventually cause performance issues by consuming system resources and slowing down queries and reports. If you cannot delete this data because you need it for auditing or for historical purposes, set up an archive rule to archive the data and remove it from immediate access to free up system resources. You can then set up a destroy rule to delete the data after a specified period of time. Destroy rules are available starting with the Helsinki release. Figure 1. Sample Benefits of Archiving Data Data archiving supports domain separation. For example, incidents that belong to a domain keep their domain designation even after they are archived. Note: If you want to archive email, activate the Email retention plugin and use the archive and destruction rules that come with the plugin. Do not use the archive feature to create your own archiving rules on the Email table. Tables and modules created by an archive ruleThe first time you activate an archive rule, it performs the following actions:Activate data archivingThe Data Archiving plugin installs the System Archiving application.Create an archive ruleThe System Archiving application includes several sample archive rules that illustrate the archive features. Related records can be added to an archive rule, and you can view an estimate of the number of records the rule affects.Create a destroy ruleCreate a destroy rule to delete archived records after a specified amount of time.Change an archive scheduleAll active archive rules are executed by a system scheduled job set to run every 60 minutes. You can modify the job if you need to change the interval.Query archived tablesArchived tables are not optimized for ad hoc queries. They only contain index entries for the display value, creation date, and the primary key of sys_id.Setting the language of archived stringsOn internationalized instances, the archive process uses the language of the SYSTEM user to select the display value strings.Verify the number of records affectedEach archive rule provides an estimate of the number of records the rule affects in the Record estimate field.Archive related recordsUse the Archive Related Records related list to add related records to the archive rule.Archive a restored recordArchive rules will not archive restored records. In order to archive a restored record you must manually archive the record. View archived dataYou can view archived tables from the Archived Tables list.Restore archived dataWhen you restore a record, the instance inserts it back into the primary table and flags the record as having been restored in the log.