>>Jim,
>>>
>>>2) REINDEX (except in VFP7SP1) will remove CDX "bloat" of both the deleted TAG variety and the 'random inserts causing extra nodes' variety. A smaller file is always better and I should think especially so where it is a .CDX. A REINDEX will also result in a 'contiguous' (as much as available RAM will allow) .CDX file as its output.
>>>
>>
>>You're confusing index size with index bloat. REINDEX command in any version of VFP will remove index bloat.
>
>Well I'd like to know how you can conclude that with the evidence at hand. I have shown that a VFP7SP1 REINDEX does not shrink the CDX, nor grow it (by any more than 512 bytes and only in some cases).
>In this case, how can you be so sure that "bloat" is removed????
In part, based on your tests posted at
http://fox.wikis.com/wc.dll?Wiki~CDXBloat~VFP. See #7. I quote "CDX size is reduced in all releases".
--sb--