RE: Informix 7.21.UC1 spontaneously corrupted indexes

What's all this about 7.21....I thought 7.2 hadn't even been released yet. I presume you are talking about 7.12?? This release did have some problems..... Jon ----------------------------------------------------------------------- Jon C. Vemo jvemo@cyberspace.com Bothell, WA USA ---------- From: Tom Downs[SMTP:down0041@maroon.tc.umn.edu] Sent: Saturday, June 22, 1996 11:18 AM To: informix-list@rmy.emory.edu Subject: Re: Informix 7.21.UC1 spontaneously corrupted indexes I don't claim to be an expert on 7.21. However, I have seen several times when an index has spontaneously gone bad (v4.1). In these cases it was due to an index on a field that had 64,000 or more of the same values. For example, in a customer table with 300,000 rows. If there is an index on a field "middle initial", the index will likely go bad if any one letter appears more than 64,000 times. The solution in this case is to make a composite index of "middle initial" and another field. preferably an integer such as customer number. create index i_midinit on customers (midinit,custnum) Hope this is of some use...