RE: DELETE ROWS - how to recover disk space

Posted in 1999

Rekaish Bhardwaj — Wed, 17 Nov 1999 10:58:40 -0000 — source: Informix-list mailing list archive (1991-1998)

The only way I know of to get your space back is to unload the data, drop the table and reload the data. Rekaish -----Original Message----- From: Valerie [mailto:vgerauxNOvgSPAM@caramail.com.invalid] Sent: 17 November 1999 09:22 To: informix-list@iiug.org Subject: DELETE ROWS - how to recover disk space Hi! When I perform this : DELETE FROM <table> WHERE <condition>; Rows are deleted, but I cannot recover the disk space. I know that free rows are used later by new records, but today my disk is more than 95% full and processing time is excessive. Please help me to recover disk space. Any idea will be greatly appreciated. Valerie. * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful