Re: Does Index get updated ??

Dear sat0789,

You can find detailed explanation about what happens when you update without changing values in this article
http://www.jlcomp.demon.co.uk/10_update_cost_i.html. Jonathan Lewis explains all aspects of updating without changing values.

On Fri, 08 Oct 2004 15:06:25 -0700, sat0789_at_fastmail.fm <sat0789_at_fastmail.fm> wrote:
> Hello All,
> update a
> set loan_key = 123,
> b = bbb
> c = ccc
> where loan_key = 123
>
> will this update statement also cause the index to be updated even
> though the column value does not change.

--
 Edgar
--
http://www.freelists.org/webpage/oracle-l