When using databases the system keeps a note of the location of each record in the file by the prime and secondary indices. When adding records to a file the system keeps a note of the indices of the new records in a temporary area of the database. At some point these indices are ‘tidied’ into the permanent index blocks – usually on exit or entry into the database when a single user is accessing the file. This option allows you to perform an index tidy on the database at your own discretion.
Other than selecting the ‘option type’ and the database to process no further settings are required.
Article ID: 1214
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/i-â€-index-tidy-1214.html