>>My suspicion is that all this is dealing with symptoms. Something else is probably causing these file read errors, which is manifesting as problems with your CDX(s). The CDX(s) may or may not actually be bad.
>
>But recreating them is the best way to eliminate mentioned uncertainty...
For you and Dragan: Yes,
for now. Then you run the app, everything is OK for a while. Then it happens again. So, do you:
- Recreate again, then wait for another failure (lather, rinse, repeat)? Someone famous once defined that as insanity
- Indexes don't get corrupted for no reason. If that's what's actually happening, something else is wrong. That reasoning applies to the *first* instance of a CDX going bad. So, right from the start it's important to look for root causes, not just keep treating the symptoms
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up