Re: Update statistics.

No, It is supposed to enhance perfomance by optimizing the index access. You must have accidentally impacted one or more indexes therefore infomix is trying to do a sequential access for the queries involved in your programs. You may want to generate dbschema for the whole database, extract all indexes and compare them with the originally designed index scheme to isolate what you are missing. Thanx. Ravi.