Re: Minimizing Extent?
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.
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