Updating a column in oracle my dating site

24 Aug

I mean, Come on, who would not know the ASCII representation of their first name in hex?

Introduction If a table column is updated with the same value in a row, does Oracle RDBMS engine modify the data?

(or) Does RDBMS engine have an optimization skipping the update, as value of that column is not changing?

This was the essence of a question asked in Oracle-l list and I think, it is a good topic for further discussion.

Jared Still came up with a fine method to understand this issue measuring redo/undo size.