Re: Logical block corruption
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 1 Apr 2009 18:13:08 +0000 (UTC)
Message-ID: <gr0ark$r7f$5_at_solani.org>
On Wed, 01 Apr 2009 10:04:30 -0700, jgar the jorrible wrote:
Date: Wed, 1 Apr 2009 18:13:08 +0000 (UTC)
Message-ID: <gr0ark$r7f$5_at_solani.org>
On Wed, 01 Apr 2009 10:04:30 -0700, jgar the jorrible wrote:
> Wouldn't that be using a corrupt index to make a new corrupt index? Or
> did I miss a joke?
Nope, it would not. The "rebuild" option essentially drops & re-creates an index. There is another option, "coalesce", which re-balances it, sort of. Coalescing an index does not change the level of the index being coalesced, so even if you deleted most of the records, the level of the index will remain the same after coalescing. It will not remain the same after a rebuild.
-- http://mgogala.freehostia.comReceived on Wed Apr 01 2009 - 13:13:08 CDT