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
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 PROTECTED]
Subject: GROUP BY performance on large tables
Hi: Issuing