>Does anyone have a good, quick, reliable way to identify an index as being corrupt?
>
>I've got an app that has an occasional problem with index corruption - but am relying on the user's to spot something wrong. I want to be able to tell them something is wrong - or better yet - fix it before they notice.
I agree with Craig - it isn't worthwhile, since under normal circumstances, index corruption is a very infrequent problem.
Make sure that you FLUSH after making changes to records, and make sure to turn off write-cache.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)