Re: GROUP BY ...speed issue

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
Received on Tue Oct 07 1997 - 00:00:00 CDT