The use of indexes
Number of Index
This is the number of indexes defined for the file.
File number for index files
This is the file number that is used to identify the indexes in a file. The files physical properties are defined in the PMINIT__.DAT file.
Growth percentage per index
When a file is opened, the necessary indexes are read into memory. The size of the index can be the maximum size defined in the field Maximum Size of Index (NAME) or it can be set to the actual size of the file, plus an additional percentage of the actual size. A value of zero means that the Maximum Size of the Index is used to allocate the memory requirement to the index.
Maximum size of index
The maximum size allowed for an index. It is used to limit the amount of memory an index can occupy.