Re: [Q] How oracle rebuild index internally?

["Richard Foote" <richard.foote@xxxxxxxxxxx>]

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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; <oracledba@xxxxxxxxxxx>
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@xxxxxxxxxxxxx
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
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

• References:
  • [Q] How oracle rebuild index internally?
    • From: dba1 mcc

Other related posts:

Re: [Q] How oracle rebuild index internally?

Re: [Q] How oracle rebuild index internally?

Re: [Q] How oracle rebuild index internally?