Re: Index reorganization

From: <ashesh48_at_my-dejanews.com>
Date: 1998/11/30
Message-ID: <73v4mf$vbb$1@nnrp1.dejanews.com>#1/1

IF u are using v7.3x then u can use the
Rebuild index instead of creating and dropping...

HTH
Ashesh

In article <365FBE51.E018E4DD_at_realtech.de>, Marco Mainini <mainini_at_realtech.de> wrote:
> Hi,
> Can anybody help me please.
> I'm a relatively newbie DBA and I've to reorganize a tablespace
> containing 3000 indexes. Which is the fastest way to accomplish the
> work? How can I drop and recreate all the indexes?
> Thanks for any help in advance.
>
> Marco
>
> ==============================
> Marco Mainini
> mailto:mainini_at_realtech.de
> ==============================
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 30 1998 - 00:00:00 CST