>>Hallo Everybody,
>>
>>We have developed a applicaiton for one of our customer, the data
>>base size is about 40MB all put together, nowadays we are facing
>>lot of index corruption problem. Everyday morning we are doing
>>recreating the index. Is there any solution, to identify this
>>problem. What is the cause for this index corruption.
>>
>>We are using UPS also.
>>
>>Regards
>>
>>Logamoorthy
>
>If your application runs as standalone only, then indexes are vulnerable to corruption everytime there are improper exits done by users or maybe when some technical problems occured that closes you application abnormally.

Another common cause of index and data corruption is improper index use. If you try to update one of the index's key field and the tag is active at that moment, will eventually corrupt. That's my experience on this subject.