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 >