SQL Statment

From: Daniel Cukier <danicuki_at_linux.ime.usp.br>
Date: Wed, 16 Jun 1999 16:26:30 -0300
Message-ID: <7k8vrg$2qls@enews3.newsguy.com>

Is there anything wrnog with this SQL statment?

"select rep.repnomfan, sum(pedtotinf) venda from puket.avpeca, (select repcod, repnomfan from puket.coreca where repstacod = 'A') rep
where rep.repcod = avpeca.repcod
group by rep.repnomfan
order by venda"

table puket.avpeca has 35000 rows

the search takes 6 secons. It is normal?

---

Daniel Cukier
danicuki_at_linux.ime.usp.br
UIN: 5570114

---

Received on Wed Jun 16 1999 - 14:26:30 CDT