Re: Rebuild indexes
- From: Arul Ramachandran <contactarul@xxxxxxxxx>
- To: peterdixon001@xxxxxxxxxxx
- Date: Sun, 22 May 2005 23:06:59 -0700
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@xxxxxxxxxxx> 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?
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
--
//www.freelists.org/webpage/oracle-l
Other related posts:
