Re: table extents cleanup

Posted in 1996

PLKapp — 5 Jul 1996 09:03:42 -0400 — source: Informix-list mailing list archive (1991-1998)

-- Mark Blum (markb@raysfood.com) Wrote: >> We use Informix Online 5.05. Does anyone know of 3rd party software or >> another way of doing table extents cleanup. We are currently using >> dbschema and unloading to a file, re-creating the table with larger >> numbers then re-loading the table. I don't know if this works for Online 5, but creating a clustered index (or altering an existing index TO CLUSTER) will reconstruct the table into a single extent, if possible. This is a nice trick, since it even works on the system tables. Just drop the index (or alter to NOT CLUSTER) when done. Paul Kapp ----> PLKapp@aol.com -OR- plk@interactive.visa.com