Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rebuild indexes
Are there updates to any of the indexed columns? When an update changes at
least one indexed column, it is treated as an insert ( of the new value )
and a delete ( of the old value ).
-Arul
On 5/22/05, Peter Dixon <peterdixon001_at_hotmail.com> wrote:
>
> I have an application where data is never deleted, I have just rebuilt an
> index which was previously 4gb in size and its now 3gb in size. Can
> anybody
> explain?
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
-- -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 23 2005 - 02:11:42 CDT