Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rebuilding indexes
Message
De
23/10/2000 21:03:42
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
23/10/2000 15:04:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00433093
Message ID:
00433263
Vues:
14
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform