Re: GROUP BY ...speed issue

Yes... there is approximately 12 million records in the RECIPIENT table and 110 thousand records in the FREQ_COUNTR_1996 table.

Why do you ask?

In article <343ab5ef.4415078_at_news.cybernex.net>,   nwhitehead_at_rocketmail.com (nwhitehead_at_rocketmail.com) wrote:
>
> If you are running the CBO, did you compute or estimate statistics ?
>
> Nick
> nwhitehead_at_rocketmail.com
>
> >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
> >(QNAME, Extention, QVALUE, COUNT)
> >select c.qname, c.qvalue, count(*)
> >from system.recipient R, freq_counter_1996 C
> >WHERE r.qname=c.qname and
> > r.response in (c.qindex, c.qvalue)
> >group by c.qname, c.qvalue;
> >
> >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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet