Re: Rebuild index

From: <wasim_ahmed_at_my-deja.com>
Date: Mon, 23 Aug 1999 12:37:15 GMT
Message-ID: <7prf9q$upd$1@nnrp1.deja.com>

alter index index_name rebuild
regards,
Wasim

In article <7prbnl$sbr$1_at_nnrp1.deja.com>, wasim_ahmed_at_my-deja.com wrote:
> In article <687w3.50$di5.273_at_news.get2net.dk>,
> "Søren Lauritzen" <sorenl_at_rki.dk> wrote:
> > How to rebuild an index?
> >
> > Thanking you in advance.
> >
> > Søren
> >
> >
>
> First drop the index on respective table and column like
>
> (select index_name from user_ind_columns
> where table_name = table_name AND column_name = column_name);
>
> drop index index_name;
>
> create index index_name on table_name (column_name);
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 23 1999 - 07:37:15 CDT