You are correct -- in the "old days" (FPW 2.x), this was fairly easy to do, and most of us built some sort of "Rebuild Indices" routine into our applications to take care of this problem. We also learned to avoid the REINDEX command...it provides a quick fix in most cases, but was technically unsound for various reasons.

In VFP, however, one cannot just blow away tags and/or .CDX's as in FPW. The .DBC contains data about certain types of indices and referential integrity, and you need to consider this when you rebuild an index. You may want to look into the ALTER TABLE command...it will enable you to rebuild primary, candidate, and foreign keys, as well as do various other things to your tables. However, be forewarned about ALTER TABLE...be careful, and be sure that you know what you are doing.

Hope this helps -- Bill

>The .cdx files are supposed to be compact but over a period of time they tend to increase in size.
>
>In Fpw26 you could periodically delete all .cdx files and recreate them. But in Vfp if the tables are part of a database, you can not delete the .cdx files since when you open the database, vfp gives an error message.
>
>Is there a way to re-create the .cdx files so that they remain true to their name?!
>
>Please tell me if you have found a way!
>
>Eswar
>26.06.98
>India