| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to check if index was updated?
You are right Ric, just needed to prove it to my developers so they
can revert to the age-old syntax of using only columns that need
update.
This new syntax of row update makes it easy to write and requires less maintenance for developers, but <drumroll please> ... they are willing to listen.
Raj
On 4/27/06, Ric Van Dyke <ric.van.dyke_at_hotsos.com> wrote:
> Ah this puts a new twist on the question! If the update has all the
> columns from the table in the set clause, then yes the indexed columns
> will get updated. There will in effect be no change, but the update
> activity will take place. This means all the latching, pinning, redo
> and undo generation of the indexed blocks will take place, even though
> the value in end stays the same.
>
> It's best to write the update that only includes the values being
> updated. For example if the only field that changed is the Street
> Address, then only put the Street Address in the set clause of the
> update. Put what ever is necessary in the where to only get the row you
> wanted updated.
>
> Ric Van Dyke
> Hotsos Enterprises
> Cell 248-705-0624
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 27 2006 - 06:30:44 CDT
 |
 |