Re: rebuild indexes

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 06 Jul 1999 13:57:28 -0400
Message-ID: <37824388.8346C0DA@Unforgettable.com>

Yes, however be very careful about your tablespace and storage usage. If you do not specify a tablespace then the index will be rebuilt into the default tablespace for the schema you are logged in under - disasterous if you are logged in as SYSTEM. If you do not specifify storage parameters then they will follow the parameters for the tablespace in which the index is created and that will almost never be correct.

Ken

Tralyn wrote:

> Not having access to a 7.3 book currently I had a similiar
> question. Will using the REBUILD option do the same stuff
> as actually dropping and recreating the index?
> Thanks
> Traci'
>
> **** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****
Received on Tue Jul 06 1999 - 12:57:28 CDT