Update performance

[ETLMaster]

Hi there,
I'm running a PL/SQL script that is doing updates using a statement like this:

update t set
id = decode(id,a,b,id),
id1 = decode(id1,a,b,id1),
and so on.

This statement is being invoked within a forall statement so I'm avoiding the expensive SQL-PL/SQL context switch. Is there any other way to improve the performance of this update staetement?

Thanks in advance!

 

[sem]

In most cases you may improve performance by optimizing your WHERE clause, but in this case I can sugest nothing Regards, Dima