Re: logical and physical size

>Sender: informix-list-owner@rmy.emory.edu >Reply-To: clee@acustaf.acustaf.com@acustaf >X-Informix-List-Id: <list.14798> > >Hi: > >I have a table growing really big and I try to >delete some of the records. >After I delete records, the physical size of the >table doesn't reduce as we expect. Do I need >to use informix command to reduce the physical size? When rows are removed from a table, the extents for that table do not always get removed from the physical table (npused). This is because some of the rows may be at the end of the physical table. To reclaim and compress the table, you will need to alter one of the indexes on that table to cluster. This will reorganize the table and compress out excess space. Madison Pruet