Re: Index Questions

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 15 Jul 2004 03:41:01 -0700
Message-ID: <b6beca79.0407150241.6de9e1bc@posting.google.com>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<G_nJc.44791$yd5.40929_at_twister.nyroc.rr.com>...
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:b6beca79.0407140040.2ea8fab8_at_posting.google.com...

> > > 2. Rebuild an Index that may be corrupt or have
> > > invalid data?
> >
> > ALTER INDEX .... REBUILD. you can use this to move indexes as well.
> --snip--
>
> hmmm ... if an index is corrupt or has invalid data ... and one uses alter index rebuild ...
> won't that command use the index itself to (re)build. In that case, the rebuilt index
> will have the same corruption / invalid data.

I believe that you are correct and I am wrong.

> Isn't the correct/safer way be to recreate (drop - create) the index?

Yes.

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Thu Jul 15 2004 - 05:41:01 CDT