Re: De-fragmenting tables. Some questions

An even easier way is to use the "ALTER FRAGMENT ... INIT ... " to rebuild the taregt table wherever you want. For a big table I'd do it at odd hours with logging off so you don't get bit by a long transaction. Greg Thomas J. Girsch wrote: > > Expanding on Art's expansion on David's suggestion: > > A quick-and-dirty way I used to use to defragment tables was to do an ALTER > TABLE NEXT SIZE to set the next extent size sufficiently high, and then do > ALTER INDEX <pick-an-index> TO CLUSTER. Be warned, though, that this method snip....