Re: Oracle 9.2.0.1.0 For Windows performance question

> SELECT
> kod_w || kod_p || kod_g || rodzaj_g, sum(decode(e,'N',1,0)) N,
> sum(decode(e,'U',1,0) U -- etc
> from tabelka
> group by kod_w ||kod_p||kod_g||rodzaj_g
>
> and you can throw away the trash you are using now.
>

Thank You very much. I didn't know about DECODE function. But what about SELECT count(*) from TABELKA; It takes quite long time Received on Sat Aug 23 2003 - 11:11:39 CDT