Re: Rebuild Index

From: Erik <ecotsonas_at_saraswati.com>
Date: Mon, 14 Jun 1999 16:44:12 GMT
Message-ID: <7k3bgp$tai$1@nnrp1.deja.com>

In article <7k2s9n$ngo$1_at_nnrp1.deja.com>, dipenk_at_my-deja.com wrote:
> IS it possible to rebuild an index that is the
> primary key of a table? I have an index that has a
> lot of deleted rows when I validate its structure
> and I want to rebuild it. Can I do this simply
> using the REBUILD command?
>
> Thanks in Advance.
>
> Dipen Kotecha
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Yes,

ALTER INDEX [schema.]index_name REBUILD

Erik
--
Consultant
Saraswati Systems Corporation - (SSC)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 14 1999 - 11:44:12 CDT