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