Re: Logical block corruption

From: Mladen Gogala <>
Date: Thu, 2 Apr 2009 07:35:27 +0000 (UTC)
Message-ID: <gr1prv$pme$>

Na Wed, 01 Apr 2009 13:15:35 -0700, jgar the jorrible napisao:

> "When you rebuild an index, you use an existing index as the data
> source. Creating an index in this manner enables you to change storage
> characteristics or move to a new tablespace. Rebuilding an index based
> on an existing data source removes intra-block fragmentation. Compared
> to dropping the index and using the CREATE INDEX statement, re- creating
> an existing index offers better performance."

On the other hand, when I manipulate the table, for instance by moving it to another tablespace, it suffices to rebuild the index. It cannot use the old index as the input because rowids are quite different.

Received on Thu Apr 02 2009 - 02:35:27 CDT

Original text of this message