Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!think.com!spool.mu.edu!uunet!sdrc!cinnet!eric
From: eric@cinnet.com (Eric Bardes)
Newsgroups: comp.databases
Subject: Re: resizing Informix-SQL tables
Message-ID: <1991May31.030721.24913@cinnet.com>
Date: 31 May 91 03:07:21 GMT
Article-I.D.: cinnet.1991May31.030721.24913
References: <841@tiamat.fsc.com>
Organization: Cincinnati Network, Cinti. OH
Lines: 20

From article <841@tiamat.fsc.com>, by jim@tiamat.fsc.com ( IT Manager):
> Under Informix 3.3, if I wanted to re-size the physical files in which
> Informix table data was stored (e.g. table.dat and table.idx), I could
> run
> 
> $ dbbuild -r schemafile
> 
> and during the rebuild process file space would only be used for the
> records which were actually in the table (i.e. file space used by
> "deleted" records would be freed).
> 
> Is there a similarly simple process under Informix-SQL 4.0?

Try alter index tablename to cluster.  This frees the unused space allocated
by the data and indexes in your table (file in 3.3 lingo) and as a bonus sorts
it into physical order.  (Something which _could_ be done with a very good
sorting program)

Eric Bardes		{uunet!uceng!}cinnet.com!eric
All opinions are mine - No warranty is implied or given