Hello everybody,
I just had a case of a corrupted index. I have a table with around
250,000 records and close to 400 mb, I had to move almost half
of the data to a different place after I moved the data I deleted
the records from the table without packing it, a few days later ,
records started to "dissapear", well, I found that the index was
corrupted, I deleted the index and created again, guess what ?,
we lost 10,000 records !!. Does anybody have any clue why this happened ?. Have somebody had a similar experience ?
Any suggestion is welcome.
Thanks in advance.