RE: Optimizing dbspace

Posted in 2000

Elena Korol — Fri, 11 Aug 2000 15:04:31 -0700 — source: Informix-list mailing list archive (1991-1998)

By "optimizing" I meant "free up a space in db chunks" after update statistics run. EK. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Friday, August 11, 2000 1:28 PM To: ekorol@styleclick.com; informix-list@iiug.org Subject: Re: Optimizing dbspace From: Elena Korol <ekorol@styleclick.com> > >I have a quite large table that acquires about 3 million rows a month. >Every >two weeks we purge the data by unloading it to a backup and deleting the >"old" information. >We do run 'update statistics' every time when deletes are performed. > >But it looks like it does not optimize the dbspace and I keep adding new >chunks. >What will be the best way do deal with this situation? "optimize the dbspace"?? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com