Over a period of time records are added to and deleted from the database and although there are unused spaces in the file where records have been deleted, there may not be spaces at the end of the file.
This option removes all spaces and rewrites the active records from the beginning of the file so that all available spare records are left at the end of the file. Note that on a prime-indexed file this does not affect the value of the prime-index, but on a file where record number processing is in use this option will alter the record numbers for some or all records and this may require follow-on pointer audits etc.
Other than selecting the ‘option type’ and the database to process no further settings are required.
Article ID: 1215
Created On: Thu, Jun 28, 2012 at 4:00 PM
Last Updated On: Tue, Jun 20, 2023 at 5:30 PM
Online URL: https://kb.datafile.co.uk/article/k-â€-krunch-recover-file-space-1215.html