Re: resizing Informix-SQL tables

Path: emory!hubcap!gatech!ukma!rex!spool.mu.edu!uunet!sdrc!cinnet!eric From: eric@cinnet.com (Eric Bardes) Newsgroups: comp.databases Message-ID: <1991May31.030721.24913@cinnet.com> Date: 31 May 91 03:07:21 GMT References: <841@tiamat.fsc.com> Organization: Cincinnati Network, Cinti. OH 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