Re: Index on Informix Online 7.22 ?

Posted in 1998

Carlson@WHSmith — Tue, 01 Dec 1998 21:49:00 GMT — source: Informix-list mailing list archive (1991-1998)

Jung-Hui Cheng wrote: > > I have installed a new Informix Online Dynamic Server 7.22UC3 on our > server (HP-UX > 10.20). I find it is much much slower than the Informix 7.12 Online DS > server if I do not > create index for a same program. Why and what is the difference between the> two version > of Dynamic servers ? > I'll check the obvious first . . . . 1. Have you run UPDATE STATISTICS against your tables? If the optimizer doesn't have an idea of the statistical breakdown of your data, if may resort to sequential scans. 2. What is onconfig variable OPTCOMPIND set to? If it's set to 2, you may be getting sequential scans. Just a few . . . . John Carlson Informix DBA WHSmith USA