>>>>Thread on the topic:
Reindex making DBC grow... Thread #
886832 Message #
886832>>>>
>>>>
Re: REINDEX - Without EXCLUSIVE. Thread #
841224 Message #
841605>>>
>>>I think your original answer to recreate is probably the best way
>>>
>>>I have just done a disp status to a text file - I can now cut and paste that into a program and be 100% sure of creating the correct indices
>>>
>>>Thanks for all your help
>>
>>See
Question about the REINDEX command Thread #
1003134 Message #
1003134 that confirms Sergey's comment.
>
>Interesting though
>
>My database has 293,000 records with 54 indexes - original size of cdx file 176,084 kb following a pack and reindex
54 indexes seems like an awful lot. Remember the fewer indexes, the faster it will reindex and the smaller the index file.
>
>I ran a disp status to a text ile - imported the text file into a dbf - wrote a program to delete the index file and rebuild based on my database
>
>Resultant size of cdx file exactly the same - but I ha to prove it to mysel!!
>
>Is Sergey ever wrong?????