>>>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".
Right, and that mis-adventure is regarding TAG deletion only. Please note that I used the word "both" in my original. Do you wonder why the second tests for "insertion bloat" were never delivered, as the article in question said they would be???
cheers