How to Calculate the Approximate Size of an .IDX File

ID: Q88943

The information in this article applies to:

Microsoft FoxBASE+ for MS-DOS, versions 2.0 and 2.1
Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
Microsoft FoxPro for Windows, versions 2.5 and 2.5a

Using the formula below, you can calculate the approximate size of an .IDX index file. This information may be useful in planning the disk space required for an application.

The following formula approximates the size of an .IDX file to index a database on a specified key field:

   RECCOUNT() * Length of key field * 3

Additional reference words: FoxWin FoxDos 2.00 2.10 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgTable

Last Reviewed: July 5, 1995