Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rebuild Index

Re: Rebuild Index

From: <masnani_at_corp2.pagemart.com>
Date: 1998/03/30
Message-ID: <6fouio$vuu$1@nnrp1.dejanews.com>#1/1

Dave,
I haven't really checked now, but am not sure if the alter index... rebuild command analyzes the index. As far as I remember , it does not. - Manish
> Dave Wotton wrote:
>
> > There are differences.
> >
> > Rebuild the index works faster because it builds the new index from the
> > contents of the old, rather than needing to re-read the data rows.
> >
> > It also means that people can continue to use the old index during the
> > rebuild process ( although they won't be able to update ).
> >
> > ALTER INDEX ... REBUILD will need enough free space to be able to have
> > both the new index and the old one present at the same time, as the
> > old index is only removed once the new one has been built.
> >
> > ALTER INDEX ... REBUILD will create the new index in your default
> > tablespace, using the default tablespace space parameters, unless you
> > provide tablespace and space parameters when you rebuild.
> >
> > ALTER INDEX ... REBUILD also analyses your index when it rebuilds it.
> >
> > Dave.
> >
> > --
> >
> > To reply by email, remove the "no-spam" bit from my email address.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 30 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US