Re: altering extent sizes

Hi Neil: Do you mean to use command "Alter fragment ....init ...." to defrag the table, then use command "Alter table modify next size" to increase the next extent size to avoid large number of future extent (due to growth)? THANKS !!!! Kenneth Ma Neil Truby wrote: > Kate_Tomchik@homedepot.com wrote: > > > > What does it mean to alter fragment init? > > It's an SQL command that initiates fragmentation across dbspaces or > removes fregmentation from a table. However, if you use it on an > unfragmented table so: > > ALTER FRAGMENT ON table1 INIT in dbspace1> > (not completely sure about the syntax) > > and the (unfragmented) table is already in dbspace1, it simply has the > effect of re-building the table in dbspace1. Allied to a > > ALTER TABLE MODIFY NEXT SIZE> > statement, it will de-fragment the table. > > If the table was previosuly in dbspace2, the ALTER FRAGMENT statement > will move it to dbspace1. > > Neil Truby > Londis Holdings > London, UK