Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rebuilding indexes
Message
From
23/10/2000 21:03:42
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
23/10/2000 15:04:49
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00433093
Message ID:
00433263
Views:
13
>I have a program that rebuilds indexes in a free table. It deletes the 'cdx' file and then reads index information stored in another table to rebuild the index file. If index changes need to be made, they are modified in the information table and then the rebuild program is run.
> Tables that belong to a database, however, have their index information store in the database dbc file as well. In order for the program to rebuild the indexes in database table it would also have to update the dbc file. This looks like it will work but does not seem to be the best approach. Is there a better way to delete and rebuild indexes in a database table?

David,

Think a minute. How does the index information get into the .DBC? Doesn't it get in there when you index/reindex tables? This means that they will be updated automatically.

You will need to rebuild your persistent relationships and referential integrity constraints if you delete any of the indexes which are involved.

You can run GenDBC.PRG and look at the results. But, as Ed said, you will save time and some headaches by buying SDT.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform