Re: Optimizing dbspace

Posted in 2000

Obnoxio The Clown — Fri, 11 Aug 2000 20:27:30 BST — source: Informix-list mailing list archive (1991-1998)

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