Re: "Re-indexing" Informix

On Tue, Sep 28, 2010 at 5:21 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi Fernando, > > I just use the "index repack" name because today to solve problems with > extents we can use the "table repack" (+shrink), but you right, they are > differ things... > So.. let's say "index defrag" .... > > Today you'll only solve problems with extents using repack IF you have deleted (many?) rows from the table. If you haven't it will not solve the extents problem. Repack will not compact extents. Only rows within the already allocated extents. If the row relocation leaves some extents with just free pages (at the end of the table) than shrink will be able to release some extents. But if you don't have "holes" in the table created by deletes, it will not solve the extents issue. That would be the already requested feature for REORG a table... -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...