General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only