RE: Optimizing dbspace

From: Elena Korol <ekorol@styleclick.com> > >By "optimizing" I meant "free up a space in db chunks" after update >statistics run. There's a very good reason this hasn't happened: update stats doesn't do that. :-) Try alter fragment init in... >-----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 ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com