Re: Freeing space after delete

> Subject: Freeing space after delete > Date: Thu, 12 Jan 1995 18:37:07 +1100 (AEDT) > From: Ian Timms <itimms@vprp333q.prop.telecom.com.au> > To: informix-list@vprp333q.prop.telecom.com.au > > There has been some discussion on this with relation to Online, > but what of SE, what happens by way of space recovery if anything > when rows are deleted from a table under SE? > > Yours curiously, Ian.<g> As far as I can tell, the answer is "darn little". Because SE stores its tables in Unix files, it can mark deleted rows as available, but I have never seen it spontaneously release file space. The deleted rows will be reused before the file size is INcreased, but the only way to DEcrease the file size is to rebuild the table using one of the several methods mentioned earlier. (My favorite is ALTER INDEX TO CLUSTER.) Regards, ___________________________ O Alan __________________| R. Alan Popiel | H _________________________| Internet: | Martin Marietta, SLS | H \\ | alan@den.mmc.com | P.O. Box 179, M/S 3810 | H \\ Std disclaimers apply.| Voice: | Denver, CO 80201-0179 USA | H ) | 303-977-9998 |___________________________| H / (But you knew that!) |_____________________) H /___________________________) H