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.