Re: How to check if index was updated?
- From: rjamya <rjamya@xxxxxxxxx>
- To: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- Date: Thu, 27 Apr 2006 07:30:44 -0400
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@xxxxxxxxxx> 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
----------------------------------------------
Got RAC?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
