Re: Deletion of the data.

Posted in 2000

Sujit.Pal@bankofamerica.com — Wed, 27 Sep 2000 09:36:12 -0700 — source: Informix-list mailing list archive (1991-1998)

yisroel AFAIK, when you delete data, the extents that the table has are not reclaimed. To get the space back you would need to drop and recreate the table. HTH Sujit yisroel <yisroel@ix.netcom.com> on 09/26/2000 03:35:24 PM Please respond to yisroel <yisroel@ix.netcom.com> To: informix-list@iiug.org cc: Subject: Deletion of the data. Here is a problem I have. I have deleted data from my database. But when I check size of the database it does not go down. I did updated my statistics, but size still remains the same. Is there a way of purging data from database as well as indexes?