_total;
on delete
update count_table set total_count = total_count - 1, je_total = je_total -
:old.je_total;
hope this helps,
Dan Greene
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 26, 2003 7:34 AM
> To: [EMAIL PROTE
Hi: Issuing a simple group by like this:
select C_SF, count(*), sum(je) as sum_je
from kp_data
group by C_SF;
against a large (1.4G) table holding a 5 mln records with 60 columns
takes about 330 secs on my Win2000 development box,
a 2.0GHz P4 w/ 1G RAM and an IDE MAXT
