Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Elena Korol — — 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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.