Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!newsfeed.r-kom.de!newsfeed.freenet.de!newsfeed0.kamp.net!newsfeed.kamp.net!nx01.iad01.newshosting.com!newshosting.com!198.186.194.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!q2g2000cwa.googlegroups.com!not-for-mail
From: janik@pobox.sk
Newsgroups: comp.databases.oracle.server
Subject: Re: when rebuild IOT ?
Date: 2 Feb 2007 05:27:20 -0800
Organization: http://groups.google.com
Lines: 40
Message-ID: <1170422840.440219.190440@q2g2000cwa.googlegroups.com>
References: <45c2604f$0$21113$426a74cc@news.free.fr>
   <1170402962.860307.309960@v33g2000cwv.googlegroups.com>
   <45c2f075$0$26684$426a74cc@news.free.fr>
NNTP-Posting-Host: 193.32.3.83
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1170422845 3697 127.0.0.1 (2 Feb 2007 13:27:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 13:27:25 +0000 (UTC)
In-Reply-To: <45c2f075$0$26684$426a74cc@news.free.fr>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 emea-nc01 (NetCache NetApp/6.0.1)
Complaints-To: groups-abuse@google.com
Injection-Info: q2g2000cwa.googlegroups.com; posting-host=193.32.3.83;
   posting-account=rKgY0QwAAAAVXmnEaFAq3hgw2dJZH99o
Xref: news.f.de.plusline.net comp.databases.oracle.server:193495

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=EDsal(a):
> "Gints Plivna" <gints.plivna@gmail.com> a =E9crit dans le message de
> news:1170402962.860307.309960@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