I have a general discussion/question regarding index field getting corrupted. The created date field on one of my table were index and it got corrupted a few days ago. So the perfomance on that table ran pretty slow. However, it resume to operate normally afterward. Now, when i query for data based on the created date starting from the corrupted date and earlier, no data get display even though the data are there.
My question is, how is it possible for an index field to get corrupted and resume to work normally? Is this an internal Oracle 8i bug or what exactly would cause this? ( Any experts or someone who experienced this type of problem, please share your thoughts )...
Also, any details on why my query doesn't display data when i query based on the corrupted index field?