Re: Problem deleting records on SE

Posted in 1998

Andreas Bettin — Tue, 22 Dec 1998 16:24:35 +0100 — source: Informix-list mailing list archive (1991-1998)

Informix marks deleted records as unused, so you must normally drop the table and create the table to free the disk-space. An idea is, to change an table-index to cluster (alter index xxx to cluster) and back to not cluster. Good bye. Andy We use Carlos schrieb in Nachricht <75nh3q$bah@wendy.mad.servicom.es>... >I've deleted all records in a table, but the sizes of .dat and .idx files >are the same as before deletion. Why? > >Thanks, > >Carlos > >