poorly written query?

From: Sk8er <Sk8er.not_at_here.net>
Date: Thu, 22 Mar 2001 23:30:22 -0700
Message-ID: <uZBu6.3841$5%5.826023@news.uswest.net>

I am trying to run this particular query.................

select collector_id assessor, count(collector_id) num_assmnts,

count(hotlined_yn) num_hotlines, count(pass_move_yn) num_pins,
count(suspend_yn) num_suspnds, sum(payment_recvd) pay_recvd,
count(payment_recvd) num_pays, sum(arts_amt) arts, count(arts_amt)

arts_total from ollectr.del_acct, collectr.acct_contact where rep_review_date< sysdate and rep_review_date>= sysdate- 2 group by collector_id;

 ..............via sql*plus on an Oracle 8.0.5 database from a read only table. The sums add up more than just yesterday's date and it takes forever to process. Could someone please give me some advice as to what I might be doing wrong? Any help would be much appreciated! Received on Fri Mar 23 2001 - 00:30:22 CST