Problem:

This purpose of the configuration option INDEXCOUNT is to aid in the improvement of performance when accessing indexed files.

Resolution:

The default value for INDEXCOUNT should be suitable for most files. However, for files where the depth of the tree is greater than 4 or where there are a number of alternate keys defined for the file, increasing INDEXCOUNT can dramatically improve performance. The information required to make this calculation can be gained by using the rebuild tool to validate the file (rebuild -f filename). A general guide to setting INDEXCOUNT is as follows:

INDEXCOUNT = (Tree Depth * No Keys) No Keys

This parameter is put in the External File Handler configuration file pointed to by the EXTFH environment variable. See the File Handler documentation for specific instructions for using the External File Handler configuration options.