Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help, I am desperate: Sql problems or a bug
Hi!
I have worked a little with my sql problem and changed a bit in the script. I can see that it works fine, if I only have to update 10 rows(the full recordset is 1600 rows). But after we have upgraded to 7.3.3 from 7.3.2 on digital Unix, it is 20-30 times slower than before. Have we forgot to change a specific parameter, or is this a bug in 7.3.3.
We have created indexes on the tables.
the script looks like this:
update repport set
Use =
(select nvl(round(sum(fp.beloeb),0),0)*(-1) from ose.bundt bu, ose.fpost
fp
where fp.rgkod = '0001'
and fp.kntid = repport.actid and fp.bidat >= 19970101 and fp.bidat <= 19971231 and bu.nedtid = 0 and bu.rgkod = '0001' and bu.bdtnr = fp.bdtnr)
Please help me.
-- Casper Thrane System developer Benau A/SReceived on Tue Dec 09 1997 - 00:00:00 CST