RE: Deletion of the data.

If your first extent size is smaller than the current size of the table and there is recoverable space (from rows being deleted), then ALTER FRAGMENT ON TABLE tabname INIT IN your_dbspacenamewill decrease the allocated pages. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Jay Konigsberg Sent: Wednesday, September 27, 2000 2:19 PM To: informix-list@iiug.org Subject: Re: Deletion of the data. Are you suggesting that an ALTER TABLE will free unused pages? This is news to me. "Chuck Renaud" <chuck.renaud@informix.com> wrote in message news:8qrhpp$ern$1@news.xmission.com... > > Extents are not de-allocated just because you delete rows. If you > really need to recover the space, you need to either drop and reload > the table or do an ALTER on it. Otherwise, run oncheck against the > table to find out how much space is actually being used vs. allocated. > > > 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? >