Re: resizing Informix-SQL tables
Path: emory!wuarchive!uunet!trac2000!das
From: das@trac2000.ueci.com (David Snyder)
Newsgroups: comp.databases
Message-ID: <1027@trac2000.ueci.com>
Date: 30 May 91 11:30:08 GMT
References: <841@tiamat.fsc.com>
Organization: UE&C - Catalytic in Philadelphia, PA
In article <841@tiamat.fsc.com>, jim@tiamat.fsc.com ( IT Manager) writes:
> 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>
> Is there a similarly simple process under Informix-SQL 4.0?
My favorite way is to type the following from within Query Language...
ALTER INDEX idxname TO CLUSTER;
The idxname is the name of you most-used index. Not only will this remove
empty space, but it will put the data in the same physical order as your
index (great speed enhancer).
DAS
--
David A. Snyder @ UE&C - Catalytic in Philadelphia, PA
UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com