Re: Tuning

Posted in 1996

Partha Dutta — Sat, 22 Jun 1996 10:43:47 GMT — source: Informix-list mailing list archive (1991-1998)

jp@ciop.waw.pl (Jaroslaw Pyszkiewicz) wrote: > Does anybody have idea how to speed up such a querry. > SELECT SUM(przydzial.godziny) > INTO arr_przyd_sc[counter].suma_rok > FROM przydzial > WHERE YEAR(przydzial.miesiac)=YEAR(przyd_bufor.miesiac) > AND przydzial.zad_id = przyd_bufor.zad_id > This is description of table: > "przydzial" : zad_id INTEGER, > prac_id INTEGER, > miesiac DATETIME YEAR TO MONTH, > godziny INTEGER > It is used on small OnLine 4.1 with overloaded system but I was asked >to change code. Any suggestions ? > TIA, Jarek >jp@ciop.waw.pl Asuming there are indexes on przydzial.zad_id and przyd_bufor.zad_id, A suggestion would be to remove the YEAR filter on the where clause, and do the comparison outside in a foreach loop[ (assuming you have wriiten an application in 4GL.) +--------------------------------------+ | Partha Dutta | | pdutta@vsol.com OR pdutta@airmail.net| +--------------------------------------+