Re: Rebuild Index

Dave,

I thank you for your help. I agree with all of what you wrote...except with

"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."

I issued the following statement :
ALTER INDEX index_name REBUILD TABLESPACE tbs2;

Oracle rebuilt the index in the tablespace tbs2 (a different one) with the storage parameter of the index being rebuild (and so did not used the default storage parameter of tbs2)

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.
Received on Mon Mar 30 1998 - 00:00:00 CST