求切实提高查询速度的方法(,并且减少查询所占用的cpu资源sql server2000),请高手们帮帮忙(200分)

qry5.Close;
qry5.sql.Clear;
qry5.SQL.Add('insert findreceivezxk');
qry5.sql.Add('(no, finddate,finddate1, spellid, summD,summi,summ3 ) select  '+inttostr(no0));
qry5.SQl.Add(','''+datetostr(wwDBDateTimePicker3.date)+''','''+datetostr(wwDBDateTimePicker6.date)+''',');
qry5.sql.add('a.spellid,summD=sum(a.summD),summI=sum(a.summi),summ3=sum(a.summ3) ');
qry5.sql.add('from  OutputitemSumm a where a.status in (''3'',''D'',''I'')');
qry5.sql.add('and a.status1=''Z'' and a.orddate>='''+datetostr(wwDBDateTimePicker3.date)+'''');
qry5.sql.add('and a.orddate<='''+datetostr(wwDBDateTimePicker6.date)+'''');
qry5.sql.add('group by a.spellid order by a.spellid');
qry5.ExecSQL;  //所有的summD,summI,summ3 //该日销售有关金额

qry5.close;
qry5.sql.Clear;
qry5.sql.Add('insert findreceivezxk');
qry5.sql.Add('(no, sumall,finddate,finddate1, spellid,summda,summia,summ3a,qtyda,qty3a,receivea,sumsumma,summd1a,summi1a,summ31a,summZTa,qimoa)');
qry5.sql.Add('SELECT '+inttostr(no0)+',''A'','''+datetostr(wwDBDateTimePicker3.date)+''','''+datetostr(wwDBDateTimePicker6.date)+''',');
qry5.sql.Add('SPELLID, SUM(summD) summDa, SUM(summI) summIa, SUM(summ3) summ3a,');
qry5.sql.Add('SUM(qtyD) qtyDa, SUM(qty3) qty3a, SUM(receive+receivezt) receivea, SUM(sumsumm) sumsumma,');
qry5.sql.Add('SUM(summD1) summD1a, SUM(summI1) summI1a, SUM(summ31) summ31a,SUM(summZT+receivezt1) summZTa,SUM(qimo) qimoa');
qry5.sql.Add('FROM findreceiveZXK where no='''+inttostr(no0)+'''');
qry5.sql.Add('GROUP BY SPELLID order by spellid');
qry5.ExecSQL;