View source for 9. Purge Data

'''Purged Data'''

Database administrators purge data from tables when the table rows exceed several hundreds or even millions of records that are no longer needed. However, purging lets you archive the records even though you remove them from tables. Administrators move records from a large table to an archive table. Purging records from a large table speeds up queries.


'''Purged Data - Where would you find the purged Audit Trail Folder?'''

When '''Purging Data''', you will be prompted to name and set a destination for the exported file copy.


'''Purging the Audit Trail'''
*Select Utilities Drop Down menu
*Select Audit Trail
*Select Purge Audit Trail
*Enter name of file to archive the records before purging
*Select OK


Purging the audit trail does not lose the data. It is important to purge the Audit Trail on a regular basis as it will otherwise slow ERP as the file grows.