Re: your mail

uunet!rhlab!kuhn, in your mail you wrote: > > Here is a bit of performance information I would like to pass on. > In running the query described below on my OLD version performance was > completely acceptable. On version 4.0, ouch!!!! Queries that took seconds > were now taking lots........ of minutes like 15,20,25 minutes. > We experienced the EXACT same type of problem that your describing. The only difference is that we're using a Compaq 386/20e with SCO Unix 3.2.2. As you have stated, Informix technical was no help with this problem but after close investigation we were able to solve it. Remember one of the basic rules of indexing... don't place an index on a row containing only a few possible values. Example: sex (M or F), answer (Y or N) What we found is that the old optimiser was more forgiving with these type of indexes... our solution was to make a composite index using the sex field along with another field to provide more unique indexes. Hope that helps... DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@ueci.com