Re: how to estimate space saved with index reuild

if you run:

select sum(bytes) from dba_free_space where tablespace_name = '<INDX>';

where <INDX> = the tablespace name that the index in question belongs to...

run it before and after the index rebuild and you should see the amount of space that the rebuild freed up.

Hth,
Gavin

In article <9133dq$jik$1_at_nnrp1.deja.com>,   Allan Plesniarski <aplesnia_at_my-deja.com> wrote:
> Hi, we have a tar|gzip of a production database that takes too long.
> One suggestion for shortening the time is to rebuild the indexes,
> thereby removing the deleted nodes and shortening the tar|gzip time.
> In order to do a cost/benefit analysis, how does one estimate the
> amount of space freed after rebuilding an index?
>
> Any other way to speed up a tar|gzip?
> Database size is approx 50 GB.
>
> Thanks,
> Allan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 11 2000 - 12:01:09 CST