>
>Craig, in DataFlex I wrote a routine that would run through the file serially with no index in place counting the records. Then I would run through again with each index active counting again. Then compare the counts. This seamed to help disclose a busted index. What do you think about this method?
>
>It would probably be necessary to distinguish between Rushmore aided counts (SET OPTIMIZE ON) and plain counts (SET OPTIMIZE OFF).
>
>I had a case the other night where I was looking for records with a particular date-time. With Rushmore on I asked:
>
>COUNT FOR tStart = ltStart
>
>I would get a small number. But if I turned Rushmore off I would get a much bigger number.
>
>I deleted all of the indexes (DELETE TAG ALL) and recreated them. Same problem. Then I made a copy of the table, ZAPped it, and reAPPENDed all of the records. Problem solved!
>
>
>Peter Robinson

That would be one way to check for corruption, but still does not guarantee that corruption will be detected.