Re: group by problem-URGENT !

Group by forces sorting.

Check your sort_area_size parameter. See if increasing the size improves the performance.

Regards
Jerry Gitomer

byunghee shin wrote in message <37D4DE6C.2C423DAC_at_ditco.com>...
>SELECT
>IODT.IOBS,IODT.IODT,IODT.JACD,IODT.GDGB,IODT.ACCT,SUM(IODT.IOSU)
>IPSU,SUM(IODT.IOMN) IPMN,0 CHSU,0 CHMN
>FROM IODT,IOBA
>WHERE IOBA.SUGB IN ( 'º»»ç±¸¸Å','ÇöÀ屸¸Å','ÀüÀÔ') AND
> IODT.IOBS = IOBA.IOBS AND
> IODT.IOGB = IOBA.IOGB AND
> IODT.IONO = IOBA.IONO
>GROUP BY IODT.IOBS,IODT.IODT,IODT.JACD,IODT.GDGB,IODT.ACCT
>
>I 've met some problem in execute above sql statment.
>When I execute this sql, it takes time, almonst 40 sec.
>so I test without group by function as follow,
>
>SELECT
>IODT.IOBS,IODT.IODT,IODT.JACD,IODT.GDGB,IODT.ACCT,SUM(IODT.IOSU)
IPSU
>FROM IODT,IOBA
>WHERE IOBA.SUGB IN ( 'º»»ç±¸¸Å','ÇöÀ屸¸Å','ÀüÀÔ') AND
> IODT.IOBS = IOBA.IOBS AND
> IODT.IOGB = IOBA.IOGB AND
> IODT.IONO = IOBA.IONO
>
>but I takes only 0.5 Sec !
>I just wondering what is the problem? what makes too many time
in doing
>that job?
>is there any person to show me the hint? or to give me some
commment
>when I use group by function ?
>
>I'm 1 year experience programmer. please help me.
>
>
>
Received on Tue Sep 07 1999 - 09:31:39 CDT