Re: when rebuild IOT ?

First, you should understand the life style of your table - what kind of DML, which columns are frequently in SELECT, if you want to tune it for speed or for storage etc...
And then you can play with parameters PCTTHRESHOLD and INCLUDING, maybe you can save some space by placing unfrequent columns (those not often selected) into overflow segment.

Jan

Eric napísal(a):
> "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 - 07:27:20 CST