Similar to table rotation, the data archiving feature in the ServiceNow platform can also be used to improve query and reporting performance by moving old data from the primary table to a set of archive tables. Furthermore, a destroy rule can be set to permanently delete data after a specified period of time, which should only be used when you do not require historical data for auditing or reporting purposes. For example, we can define data archiving on the Booking Request table to archive records that are a year old and further, to destroy them after a period of two years.
When we set data archiving on a table, a new table with the same name and prefix ar_ is created. The data from the original data is flattened and stored in the archive table. For example, if we apply data archiving Booking Request table, then a new table comprising of fields from the base to...
