Help, I am desperate: Sql problems or a bug

Hi!

[Quoted] 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/S