Re: Tuning

What about "create index someidx on pryzydzial(goziny,miesiac,zad_id)", that is if you do not alreay have it. Existing index, size of table and rather is is split into more then one extent information and maybe able to help further. In short the "tbcheck -pT somedb:pryzdzial" report --- LOCKS TABLE while executing!!! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Fri, 21 Jun 1996, 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 }