Re: Rebuild index

From: <wasim_ahmed_at_my-deja.com>
Date: Mon, 23 Aug 1999 11:36:21 GMT
Message-ID: <7prbnl$sbr$1@nnrp1.deja.com>

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. Received on Mon Aug 23 1999 - 06:36:21 CDT