Re: When to rebuild Indexes

As far as when, I use these rules:

1) regularly 2 ro 3 times a year
2) when blevel is > 3
3) after major loads or lots of delete action

Cheers,

Earl

On Fri, 22 Dec 2000 04:56:06
 Ruth Gramolini wrote:
>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 direccisn @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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
>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 - 08:02:32 CST