>>>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
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?????
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing