SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance of update query for single column vs multiple column

644161Jun 26 2008 — edited Jun 26 2008

Hi All,
I could not find any answer for this, does it ever matter in terms of performance updating single column versus multiple column in a single update query.
For eg. table consisting of 15 columns, what would be the difference in performance when one column is update in the single query against another update query where 15 columns are updated.

Please do keep in mind my table columns in actually could be around 150+.

Thanks for any information provided.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 24 2008

Added on Jun 26 2008

2 comments

758 views