Update performance

[pst]

My developer has a query doing an update on a table of maximum of 1500 records.
Is there anyway the developer can speed up the update performance ?

The statement is simialr to this, a very simple update stmt.

UPDATE table set col2=:xa, col4=:xb, col5=xc
where col1=:x1 and col3=:x3;

I have an index on col1 and col3.

IS there also any performance benefits if update is done for one column individually?

update table set col2=:xa
where col1=:x1 and col3=:x3;

Many thanks

pst.

[vinit]

Hi,
If the columns updated are a part of index then it will take some time..since it has to update both the table and the index.
I don't think there will be much difference in updating 1 col at a time , especially when u have only 1500 rows to be updated.

Cheers,

[pst]

Thanks a lot, Vini. But we are not updating an indexed column.

pst.