Re: Problem with Informix index

Posted in 1997

Sean Birkhead — 24 Apr 1997 05:08:06 -0400 — source: Informix-list mailing list archive (1991-1998)

In <5jj3rl$c04@lori.zippo.com>, fvc16440@bahiasul.com.br wrote: >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 Indexing problems can be caused by an index on a field where many of the records contain exactly the same value. The hashing algorithm can find life very difficult as the number of records increases. Heavily used tables can sometimes have indexes damaged for no apparent reason - in fact somebody once told me that Informix themselves recommend completely rebuilding indexes once in a while! Regards, Sean Birkhead Information Solutions (Ire.) Ltd.