Re: When to rebuild Indexes

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 22 Dec 2000 07:55:53 -0500
Message-Id: <10718.125220@fatcity.com>

I believe the command it 'alter index schema.my_index rebuild;'

Ruth
it is more important to be human than to be important ----- Original Message -----
From: "William Beilstein" <BeilstWH_at_OBG.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, December 21, 2000 4:03 PM Subject: Re: When to rebuild Indexes

In version 7.3 and above tablespaces are automatically coalesced, but if you mean to defragment the index, use the

alter index schema.my_table rebuild

Which will recreate the index by reading the previous index. You can also change the storage sizes and tablespace if you want to during the rebuild. The default is to rebuild with the same storage and tablespace as the previous index.

>>> Pablo ksksksk <p_rodri99_at_yahoo.es> 12/21/00 02:50PM >>>
Hi list:

I'd like to know when should I colaesce an index?

When should I rebuild it?
What views should I be looking at?

thank you

Do You Yahoo!?
Consiga gratis su dirección @yahoo.es en http://correo.yahoo.es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20ksksksk?=
  INET: p_rodri99_at_yahoo.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_OBG.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Dec 22 2000 - 06:55:53 CST