Re: Rebuild indexes

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Mon, 23 May 2005 16:30:29 +0800
Message-ID: <5e304862050523013051efdae4@mail.gmail.com>

If you look at Stephens post, then a reduction from free space of 30% in the blocks to 10% in the blocks (assuming pctfree =3D 10), gives around 20% gain back or around 800m from a 4G index. This would fit in quite nicely with what you are observing.

hth
connor

On 5/23/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 anybo=
dy
> explain?

>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

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

Received on Mon May 23 2005 - 04:35:13 CDT