Re: Physical sizing of tables

Posted in 1999

Ramdas Gopinath — Tue, 20 Apr 1999 09:38:23 -0400 — source: Informix-list mailing list archive (1991-1998)

You have a couple of options: 1) Unload table, save the schema, drop table, recreate table from the schema and then reload the data 2) If the Table has an index, alter the index to cluster and then alter index to not cluster. Both the options will free up space. Gopi ----- Original Message ----- From: Robert Cunningham-Brown <rcunning@itad.co.uk> To: <informix-list@iiug.org> Sent: Tuesday, April 20, 1999 6:54 AM Subject: Physical sizing of tables > How can I reduce the physical size of a table having deleted a large number > of records from that table? I am using Informix SE V5 & ISQL V4.10. > > Any help appreciated. > > Thanks, > Rob. > > >