Re: index rebuilding...

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:v3ghe8qj8vstf4_at_corp.supernews.com...
>
> "Glen A Stromquist" <glen_stromquist_at_no.spam.yahoo.com> wrote in message
> news:o%WZ9.61302$c41.1415158_at_news2.telusplanet.net...
> > I want to rebuild the indexes on one of our databases, this particular
> > one has some indexes that have what seems to be some really out-to-lunch
> > storage settings, so I want to set new ones in the rebuild.
> >
> > I want to write a dynamic script to build the rebuild statement with the
> > optimum storage params for each index, either that or find a script
> > that does such a thing, but my initial searches have proven fruitless
> > for what I want to do. Which dd tables/views should I be hitting for
> > this query to build the rebuild statement?
> >
> > suggestions?
> >
> > TIA
> >
>
> alter index rebuild can rebuild the index without knowing it's column
> definition.
> That said you would only need dba_indexes and dba_segments (the
segment_name
> equals the index_name)
> I saw a script today, but unfortunately I don't remember the author.
> The commercial version of Toad has a separate module which allows you to
> point and shoot at the problem.
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>

I could have swarn I read something either in Tom Kyte's book or on his site stating that rebuilding indexes is a bad idea? I saw something about how an index will eventually get to a state of equilibrium and you may experience slowdowns while it reestablishes that equilibrium.

you know any documentation on this? about when to rebuild indices and such? Received on Wed Jan 29 2003 - 15:24:15 CST