>Hi Craig,
>>
>>SP3 changed the REINDEX command so that it makes a single pass through the table. IMO, the drawbacks of the REINDEX command outweigh the single pass.
>
>I've heard about drawbacks on the PACK command, but not for REINDEX. Care to elaborate? Or point me in the right direction?
>
>TIA,
There are two problems:
- CDX bloat. If you simply REINDEX, the new tags will be appended to the end of the CDX file. You need to DELETE TAG to remove the space, but then, REINDEX won't work.
- REINDEX relies on the tag information stored in the header of the CDX. If this is corrupted, the index will be too or VFP won't be able to read the information. In this case you may have to delete the CDX to build the indeces.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer