Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: WHEN TO REBUILD

Re: WHEN TO REBUILD

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Wed, 8 Jun 2005 22:48:31 +0200
Message-ID: <09f501c56c6b$6ec4d120$3c02a8c0@JARAWIN>


Hi,

> There are of course special cases.

Yes, for example a bitmap index on a table with heavy DML. It will require reorganization relatively soon.

But in this case is probably better to change the index to a b-tree or change the update strategy of the underlying table.

Regards,

Jaromir

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 08 2005 - 16:57:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US