Re: Rebuilding Indexes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 4 Feb 1999 08:55:30 -0000
Message-ID: <918119624.9618.0.nnrp-02.9e984b29@news.demon.co.uk>

Depending on the number of indexes in a tablespace, and the average number of extents in each index, it might be a good idea to do the coalesce after each drop to stop fet$ from becoming extended unnecessarily.

(See my document on SMON etc.)

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

charkarin Sairlao wrote in message
<36bb092f.13650529_at_newshost.fujitsu.com.au>...
>if you are using 7.3.x you can just rebuild index without droping it
>which is a lot faster than drop and build.
>
>if you are droping all the indexes, coalesce the tableSpace which will
>produce the exact result of dropping the tableSpace and recreating,
>and it will also keep the quota information.
>All it does is defrag the tableSpace.
>
>chark
>"Jeanne" <jcman_at_SPAMMEBABY.worldnet.att.net> wrote:
>
>>tablespace
>
Received on Thu Feb 04 1999 - 02:55:30 CST