Re: Performance - Informix SE 7.22

Hi! > Tom Innes wrote: > We recently upgraded from Version 5 of the SE to version 7. At the same > time HP UX was upgraded from 9.04 to 10.10. > > When this occurred queries against the large sales tables are now > running approximately 12X slower. ( 14 hrs ) We have same problem when try a 4-GL application on SCO Unix, pearlier used under HP-UX. Cause was found, when select statements was debuged with "SET EXPLAIN ON;" dirrective. After studing sqlexplain.out file, our programmes found, that informix, in some cases, don't use indexes (although it exists for tables used in select). Problems was solutioned only after rewriting complex select statements. -- With best wishes, Pavel Alex E-mail address Internet: pavel@petrolbank.com, pavel@alex.relsoft.moldova.su Fido: 2:469/1@fidonet.org Phone: (373)2 264171