PRB: .CDX File Expands with INDEX ON Command

ID: Q105941

2.00 2.5x 2.6 2.6a | 2.5x    | 2.5x
MS-DOS             | WINDOWS | MACINTOSH

kbprg kbprb

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6, 2.6a
Microsoft FoxPro for Windows, versions 2.5x
Microsoft FoxPro for Macintosh, versions 2.5x

SYMPTOMS

When an INDEX ON command is issued, it causes the .CDX file to expand in size, even if the tag used is already in the .CDX file.

CAUSE

This behavior is caused by the way that the INDEX ON command creates entries in the .CDX file. Since multiple indexes can be placed in a .CDX file, when an INDEX ON command is issued, it attaches the new index tag to the end of the .CDX file. If this same tag is currently in the .CDX file, the reference is removed, but the space that the old tag held is not released.

RESOLUTION

To reduce the size of the .CDX file, do one of the following:

Issue a REINDEX command instead of INDEX ON to update the tags in the .CDX file. This will be slower due to the fact that all indexes are rebuilt.
-or-
Issue a DELETE TAG ALL command. This will remove all the tags in the .CDX file. You will now be able to issue an INDEX ON command without causing the .CDX file to expand more than it needs to.

Additional reference words: FoxMac FoxDos FoxWin 2.00 2.50 2.50a 2.50b 2.50c 2.60 2.60a KBCategory: kbprg kbprb KBSubcategory: FxprgTable

Last Reviewed: November 24, 1998