Re: Deleting Records on SE

Posted in 1998

Billy Wheeler — Tue, 22 Dec 1998 09:52:24 +0200 — source: Informix-list mailing list archive (1991-1998)

On 17 Dec 98, at 8:56, Carlos wrote: > I've deleted all the records of a table, but the data file and the index > file have the same size. Does anyone know what's happening? Is it normal? > How can I decrease the size of these files? This is normal behaviour. Informix marks this space as reusable. To reduce the filesize, you should drop the table and recreate it or run an ALTER INDEX TO CLUSTER. HTH. -- Ciao, Billy Some days it's just not worth chewing through the restraints...