General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Thomas.
>2) How can I check, if the index is corrupted. I tried the needreindex-function from my Stonefield
>Database Toolkit but this function does not detect the corrupted index.
SDT's NeedReindex method doesn't check whether the index is corrupted. It only checks whether the table has all of the indexes defined in the meta data (such as when you've added a new index to the meta data and now want to update the production tables).
Unfortunately, there isn't a good way to check whether indexes are corrupted. I did a lot of research into this about 10 years ago and found that any mechanism I could come up with to detect index corruption took 10 - 20 times longer than just recreating the indexes and wasn't always capable of working (some types of index corruption cause a C5 error, for example).
Doug
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