Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!crdgw1!uunet!trac2000!das
From: das@trac2000.ueci.com (David Snyder)
Newsgroups: comp.databases
Subject: Re: resizing Informix-SQL tables
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
Lines: 21

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