table compression

Posted in 1991

B.T. MacWilliams — Wed, 16 Oct 91 6:48:25 EDT — source: Informix-list mailing list archive (1991-1998)

answer to Robert Sparks: To compress the table and release the unneeded table space try the following. Alter index indexname to cluster; Alter index indexname to not cluster; The second ALTER statement will remove the CLUSTER flag from the index. See Ya, Brian MacWilliams USAMC SIMA CHAMBERSBURG