Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I had a little program that would check the number of keys (records) in each tag and compare it against the number of records in the database file. If it didn't match, rebuild the index.
>
>Thanks for the reply, Vernon. Would you mind sharing that program here, or if not, maybe, explain how it worked? I'm starting to dig into the specifics of index files, and any jumpstarts would be appreciated.
Mike,
If you are interested (which I am sure you are) I have written a complete index tester program that I use on all our systems.
I was at the conference when Doug made the statement that it is easier to rebuild the indexes than to test them but with multiuser 24/7 systems I found it necessary to first confirm if there is an index problem before shutting the system down to rebuild the necessary indexes.
Todd
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement