Re: [Q] How oracle rebuild index internally?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 2 Apr 2004 07:30:53 +1000
Message-ID: <015501c41830$9c9f9f20$0100000a@FOOTE>

Yes that's true.

When you rebuild an index, all the data you require can be found in the existing index and as there are generally fewer blocks to access, it's more efficient to read the existing index.

However, if the index is corrupted, then obviously Oracle is going to struggle to perform the rebuild and a drop/recreate will be your alternate method.

Cheers

Richard
----- Original Message -----

From: "dba1 mcc" <mccdba1_at_yahoo.com>
To: <oracle-l_at_freelists.org>; <oracledba_at_lazydba.com> Sent: Friday, April 02, 2004 6:52 AM
Subject: [Q] How oracle rebuild index internally?

several days ago, I analyze my tables and indexes and found one index is bad. I use "alter index indexname rebuild;". ORACLE don't allow me to do it due to original index is bad. I wonder when ORACLE doing index rebuild it does NOT reread from table but reread from old index. Is it true?

The version we use is ORACLE 9ir2 (9.2.0.4).

Thanks.

Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Apr 01 2004 - 15:38:30 CST