Re: Index Rebuilds

Connie,

Run the following for specific index:

ANALYZE INDEX index_name validate structure;

Then:

SELECT height, lf_rows, del_lf_rows FROM index_stats;

If height > 3 (for most cases), or you have substantial rate for del_lf_rows/lf_rows (you decide - what is substantial) - then rebuild.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman_at_perceptron.com

• Original Message ----- From: "Connie Milliken" <cemail_at_sprintmail.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, June 08, 2000 1:02 PM Subject: Index Rebuilds

> How can you tell that it is time to rebuild an index? What are the
> various signs?
>
> --
> Author: Connie Milliken
> INET: cemail_at_sprintmail.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 Thu Jun 08 2000 - 14:51:40 CDT