Yes, they've got this part right. If an indexed column is "updated" to the same
value, then nothing is done to the index whatsoever. However, the redo for the
table includes the "new" value of this column even if it was the only column
updated. I suppose that is done for auditing reasons. You can however still see
that the value did not really change because there is no corresponding undo.


-----Original Message-----
Sent: Wednesday, 6 September 2000 11:19


A quick question : If an indexed column is updated to the same value, does
oracle unlink and relink the leaf block in the index, or is it smart enough to know
that if the column value has not changed, the index need not change?
My test indicate the latter, but remain suspicious that Oracle actually got something right!

Do you know offhand?