Re: Question about Extents

The best way to free previously allocated space or force restructuring of a table is to alter one of the table's indexes to CLUSTER. This will always physically restructure the table, even if the index is currently clustered. Suhas Tembe stembe@msn.com Carlos Novo Negrillo wrote in message <3587A8B3.4ED6@sainsel.es>... >I'm working with Online 7.2. > >I've seen that when Informix alocates a new extent for a table, >and later that table is erased ( not dropped ), the space previosly >allocated is not freed ... > >How can I make online to free that space for being allocated for >other table/s when needed ? > >When online alocates an extent into a coocked chunk ... is it really >contiguous in disk ? > >another Question : > >How can I compact the tables and indexes ? > > >thanks. > > > >-- >Carlos 'Nyman' Novo > >Sainsel S.A. >C/ Manuel Velasco Pando 7 >Sevilla. >e-mail : cnovo@sainsel.es