Re: Tuning

Are you missing przyd_bufor table in FROM. Also try to place zad_id before year condition. If this does not work, try creating index. SELECT SUM(przydzial.godziny) INTO arr_przyd_sc[counter].suma_rok FROM przydzial, przyd_bufor WHERE przydzial.zad_id = przyd_bufor.zad_id AND YEAR(przydzial.miesiac)=YEAR(przyd_bufor.miesiac) Susik ______________________________ Reply Separator _________________________________ >Subject: Tuning >Author: INTERNET:jp@ciop.waw.pl at CSERVE >Date: 6/21/96 2:34 PM > > >Sender: informix-list-owner@rmy.emory.edu >Received: from rmy.rmy.emory.edu (rmy.rmy.emory.edu [170.140.97.4]) by >arl-img-7.compuserve.com (8.6.10/5.950515) > id PAA15600; Fri, 21 Jun 1996 15:29:46 -0400 >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id >PAA21772 for susik_lee@united#u#group.ccmail.compuserve.com; Fri, 21 Jun 1996 >15:30:08 -0400 (EDT) >Date: Fri, 21 Jun 96 10:48:02 +0200 >From: jp@ciop.waw.pl (Jaroslaw Pyszkiewicz) >Message-Id: <9606210848.AA25896@vic.ciop.waw.pl> >To: informix-list@rmy.emory.edu >Subject: Tuning >Sender: informix-list-owner@rmy.emory.edu >Reply-To: jp@ciop.waw.pl (Jaroslaw Pyszkiewicz) >X-Informix-List-To: susik_lee@united#u#group.ccmail.compuserve.com >X-Informix-List-Id: <list.10410> 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