Re: Rebuilding indexes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 19 Feb 2002 22:32:20 +0000
Message-ID: <3C72D274.2F66@yahoo.com>

Matthieu DEGLIN wrote:
>
> Hello,
>
> My question is quite simple:
>
> Is there a difference beetween rebuilding an index and dropping et
> re-creating it ?
> Which of the 2 methods is the quickest ?
>
> Tank you.
>
> Matthieu

As as well as Mark's excellent post, you can also rebuild an index online (ie while people still make tables changes)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Tue Feb 19 2002 - 16:32:20 CST