Re:Index Rebuilds and Extents

From: Gregory Conron <gconron_at_hfx.andara.com>
Date: Fri, 5 May 2000 20:37:06 -0300
Message-Id: <10488.105123@fatcity.com>

On Fri, 05 May 2000, you wrote:
> Lisa,
>
> I lean toward the idea of having an index or table for that matter all in
> one extent if possible. Also assuming your on 8.0+ could you try using 'alter
> index rebuild' vs dropping & rebuilding from scratch? I've seen that method
> work much faster & have less end user impact.

Just make sure you have adequate disk space. Rebuilding an index takes twice as much space as dropping and re-creating, since the old and the new indexes exist at the same time, then the old one is dropped.

Cheers,
GC
--
There is something inherently wrong with the world when Bill Gates is a famous billionaire and Dennis Ritchie lives in relative obscurity. Received on Fri May 05 2000 - 18:37:06 CDT