Re: logical and physical size

Posted in 1997

Denham.M@amstr.com — 4 Jun 1997 15:28:31 -0400 — source: Informix-list mailing list archive (1991-1998)

You will need to unload the table and recreate it to reduce the file size. The data/index files are not rewritten by deleting records, hence they will only increase in size as new records/index entries are added that will not fit into the alloted space. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work) --------------------------( Forwarded letter 1 follows )--------------------- Date: Wednesday, 4 June 1997 11:55am Date: Wed, 04 Jun 1997 13:53:44 -0500 From: Chengteh Lee <acustaf!clee@acustaf.acustaf.com> To: Denham.M@amstr.com Subject: Re: logical and physical size Reply-To: clee@acustaf.acustaf.com@acustaf Denham.M@amstr.com wrote: > > What version of informix are you running and is it SE/Online? > --------------------------( Forwarded letter 1 follows )--------------------- > Date: Wednesday, 4 June 1997 10:57am > Date: Wed, 04 Jun 1997 12:14:34 -0500 > From: Chengteh Lee <acustaf!clee@acustaf.acustaf.com> > To: informix-list@rmy.emory.edu > Subject: 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? > How? > > Thanks! > Informix SE Chengteh ------------------------------------------------------------ AcuStaf Corporation Automated Staffing Systems 5001 West 80th Street Payroll, Scheduling Minneapolis, MN 55437 Time/Attendance ... 612-831-4122 ext 248 http://www.acustaf.com ------------------------------------------------------------