Re: Maintenance on Indexes
From: Alan V <alanv_at_opustel.com>
Date: 1998/03/17
Message-ID: <6emaej$6lp_at_news9.noc.netcom.net>#1/1
Date: 1998/03/17
Message-ID: <6emaej$6lp_at_news9.noc.netcom.net>#1/1
[Quoted] Why not use the rebuild option in 7.3 ? Build larger extents, too.
Alan
Gillian wrote in message <350E982F.C1FE92BB_at_entergy.com>...
>I need to cut down the fragmentation on the indexes in Financials.
>
>Is there a statement I can use to DROP and CREATE all simultaneously.
>There are about
>12526 indexes. I could probably use the DBA_IND_COLUMNS table together
>with the
>DBA_INDEXES table.
>
>Let me know.
>Much appreciated.
>
>Gillian
>zmkj04_at_hotmail.com
>
Received on Tue Mar 17 1998 - 00:00:00 CET