Re: Does Index get updated ??
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 9 Oct 2004 07:57:13 +0300
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@xxxxxxxxxxx
<sat0789@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
