Problem with Informix index

We too, have had lots of index corruption on our NCR platforms. Since we upgraded from 5.02 to 7.11, the index corruption has diminished, but not entirely gone away. My suspicion is as follows: Our application was written by a 3rd party vendor. They chose to enforce referential integrity through the engine instead of using application managed ri. This is fine, EXCEPT that several of the child tables are very large ( 1 million+ rows ), and the column(s) that the ri is on have highly duplicate values. This means that we have some HUGE linked lists of rowids for each key value. Anytime we insert, update, or delete ( which is often ), these linked lists supporting the indexes have to be rebuilt. I have a feeling that all of this rebuilding of linked lists is opening up "opportunities" for corruption. By the way, I have found that the most efficient way to fix an index is to drop it and recreate, rather than letting tbcheck repair it. Anyone else out there with lots of index corruption? Mike Ballentine --------------------------( Forwarded letter 1 follows )--------------------- Date: Wednesday, 23 April 1997 2:10pm From: fvc16440@bahiasul.com.br Subject: Problem with Informix index Date:Tue, 22 Apr 1997 14:34:13 -0500 Reply-To: fvc16440@bahiasul.com.br Organization: Bahia Sul Celulose Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.37042> Hi, Frequently I have problems with index in tables and I have used "oncheck -cI" to repair. I would like if it is normal in other installation. I am running Online 7.11 UC1 in RS/6000 AIX 3.2.5 Can anybody help me? Fabio Cruz fvc16440@bahiasul.com.br