group by problem-URGENT !

From: byunghee shin <sicaso_at_ditco.com>
Date: Tue, 07 Sep 1999 18:44:13 +0900
Message-ID: <37D4DE6C.2C423DAC@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 - 04:44:13 CDT