Re: Minimizing Extent?
Chris Burton <cburton@gte.net> wrote in article
<3314d07e.3489275@news.gte.com>...
> On 26 Feb 1997 11:23:17 -0500, twright@inbrand.com (Terron Wright) wrote:
>
> >Is there a better way to reduce table extent than onunload and onload?
> >Is there a way to do this on the fly.
>
> ALTER INDEX index_name TO CLUSTER;
> ALTER INDEX index_name TO NOT CLUSTER;>
> This will rebuild the table (it will be locked during rebuild, and you
must
> have enough space for TWO copies of the table). Be careful when doinig
> this and look at what free space (oncheck -pe) is avail for the rebuild.
> If the free space that is avail is also fraged, then your rebuild might
not
> be much better.
This is also true for unloading/reloading a table too. I unloaded a table,
dropped the table, recreated the table then reloaded it and it was put back
in the same (non-contiguous) space that it came out of.
>
> Another alternative is altering the next extent size for the table. This
> could cause better usage of the fragments (fewer larger instead of more
> smaller ones).
>
> Chris
> cburton@gte.net
>