Re: When to rebuild Indexes

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Tue, 26 Dec 2000 08:39:12 -0500
Message-Id: <10722.125315@fatcity.com>

Sorry, slip of the finger, you must specify the index name,

>>> "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> 12/22/00 07:56AM >>>
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 -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, December 21, 2000 4:03 PM

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=F3n @yahoo.es en http://correo.yahoo.es=20

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

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=20
--
Author: William Beilstein
  INET: BeilstWH_at_OBG.com=20

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

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us=20

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

Received on Tue Dec 26 2000 - 07:39:12 CST