Re: DELETE ROWS - how to recover disk space

Valerie I would suggest unloading the rows into 2 files, one with UNLOAD TO file.drop SELECT * FROM <table> WHERE <condition>; UNLOAD TO file.keep SELECT * FROM <table> WHERE NOT <condition>;dbschema ... // save off table schema DROP <table>; CREATE TABLE <table>...; LOAD FROM file.keep INSERT INTO <table>;CREATE INDEX <indexes on tables>...; ... UPDATE STATISTICS ...; A side effect of this approach is that you can resize the new table with good values for EXTENT SIZE and NEXT EXTENT, and recreate indexes with good values for FILLFACTOR. In a previous project, we reengineered a month-end process that used to DELETE from tables to one that did the above. HTH Sujit Valerie <vgerauxNOvgSPAM@caramail.com.invalid> on 11/17/99 01:21:40 AM Please respond to Valerie <vgerauxNOvgSPAM@caramail.com.invalid> To: informix-list@iiug.org cc: (bcc: Sujit Pal) 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