Re: compressing tables

Posted in 1995

Dave Snyder — 9 Mar 1995 11:03:04 -0500 — source: Informix-list mailing list archive (1991-1998)

Quoting Rock Solomon... > > I have several very large tables that I would like to shrink (delete the rows > that have already been "marked" for deletion"). First of all, is there a way > to tell how many of these blank rows exist in a table. Also, are there any > tools to shrink tables, rather than modifying it, then changing it back to > it's original form? > You could UNLOAD the table, DROP it, CREATE it again, then LOAD it. You could also ALTER one of the indexes to CLUSTER. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA WORK: ddx85qr@boots.bell-atl.com HOME: dave@das13.snide.com