GROUP BY ...speed issue
From: <schaffner_at_pewter.chrr.ohio-state.edu>
Date: 1997/10/07
Message-ID: <876259096.25988_at_dejanews.com>#1/1
Date: 1997/10/07
Message-ID: <876259096.25988_at_dejanews.com>#1/1
The following is the SQL statements that use to run in about 20 minutes. The database hasn't changed size...
INSERT INTO TEMP_FREQ_COUNTER_1996
r.response in (c.qindex, c.qvalue)
group by c.qname, c.qvalue;
(QNAME, Extention, QVALUE, COUNT)
select c.qname, c.qvalue, count(*)
from system.recipient R, freq_counter_1996 C
WHERE r.qname=c.qname and
Now it takes a day and half. I had the indicies rebuilt and still slow. The dba says that she didn't change anything. Any educated guess what may have changed to slow this down so much?
-------------------==== Posted via Deja News ====-----------------------
http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Tue Oct 07 1997 - 00:00:00 CEST