G6 Tidy Index Overflow Area

Datafile Software

G6 – Tidy Index Overflow Area

As you add details to a database with prime or secondary indexes then, if the database is in use by more than one operator, the system cannot tidy the index automatically.Usually the index will be tidied automatically when the first operator accesses the database but if in continual use the index overflow area may become full and require tiding which this option allows.

This option is identical to the I-Index Tidy option except that it can be processed automatically within a profiler Q-menu. (Note you do not need to run this option if you audit the database as this automatically rebuilds the index blocks).

Custom Fields

Release ID: Standard

Article ID: 1210
Created On: Thu, Jun 28, 2012 at 3:55 PM
Last Updated On: Tue, Jun 20, 2023 at 5:31 PM

Online URL: https://kb.datafile.co.uk/article/g6-tidy-index-overflow-area-1210.html