Re: Oracle 9.2.0.1.0 For Windows performance question

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 23 Aug 2003 16:22:13 +0200
Message-ID: <2ptekvo05igdr5vjjvmgrqg75jjcsa65jv@4ax.com>

On 23 Aug 2003 07:11:04 -0700, grzybek_at_mikrus.pw.edu.pl (Aguyngueran) wrote:

>Any suggestions

the problem is not the database, it is your sql. There should be no need to have that function, the function is causing recursive sql, which in itself is a performance nightmare already. Your main sql consists solely of cartesian products. So why do you think it should have worked at all?

Just use
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.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 23 2003 - 09:22:13 CDT