Re: when rebuild IOT ?

From: Eric <oups_at_dba.com>
Date: Fri, 2 Feb 2007 09:06:38 +0100
Message-ID: <45c2f075$0$26684$426a74cc@news.free.fr>

"Gints Plivna" <gints.plivna_at_gmail.com> a écrit dans le message de news:1170402962.860307.309960_at_v33g2000cwv.googlegroups.com...
> Eric wrote:
> > I'm on 9.2.0.5. I have noticed that some IOTs where taking as much 2 to
4
> > times space as they should. Are we supposed to rebuild IOTs, and what
are
> > pros & cons about that ?
> >
> > Thanks,
> >
> > Eric
>
> I assume that rebuilding IOT is quite the same like rebuilding index.
> If you want to know why, when you should rebuild indexes you can read
> this paper http://www.miracleas.dk/images/upload/Docs/Richard
> %20Foote.pdf and search in asktom.oracle.com site for index rebuild
> and you'll get what Tom is thinking about index rebuilds :)
>
> Gints Plivna
> http://www.gplivna.eu

Hi Gints, that's is what I was looking for.

Great thanks,

Eric Received on Fri Feb 02 2007 - 02:06:38 CST