RE: DELETE ROWS - how to recover disk space

oh I forgot you can also ALTER INDEX TO CLUSTER because it physically re-sorts the data into a copy of the table, then drops the old table. So your table is left "denser". (bit like me) isn't that right Obnoxio :-> -----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

What about the ALTER FRAGMENT ON TABLE table INIT IN dbspace ? Rekaish Bhardwaj wrote: > oh I forgot you can also > ALTER INDEX TO CLUSTER> > because it physically re-sorts the data into a copy of the table, then drops > > the old table. So your table is left "denser". (bit like me) > > isn't that right Obnoxio :-> > > -----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