Re: Physical sizing of tables

Posted in 1999

Sujit.Pal@BankAmerica.com — Tue, 20 Apr 1999 09:02:25 -0700 — source: Informix-list mailing list archive (1991-1998)

Robert On IDS and probably on SE, the only way (AFAIK) to reduce the size of the table is to UNLOAD, DROP , re-CREATE and LOAD. HTH Sujit Robert Cunningham-Brown <rcunning@itad.co.uk> on 04/20/99 03:54:34 AM Please respond to Robert Cunningham-Brown <rcunning@itad.co.uk> To: informix-list@iiug.org cc: (bcc: Sujit Pal) 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.