Re: Newby help, please - shrinking table size

In article <35587916.43D4@bayer.co.uk>, Peter Lancashire <Peter.Lancashi re.PL1@bayer.co.uk> writes >BJ Denenberg wrote: >> >> I noticed that, after purging our old call center records, the size of the >> tables themselves did not decrease. I've seen this with Btrieve tables, as >> well, but I have no idea how to remedy it with Informix databases. Can anyone >> offer some assistance, please? Thanks, >> >> BJ Denenberg >> >> To respond via e-mail, remove "hatespam." from my address. >If you mean SE tables, that's the way they work. Online too I suppose. >Using ALTER INDEX x TO CLUSTER also rebuilds the tables in current >versions of SE. Does it still in version 7.3 anyone? Yes, ALTER TABLE x ADD magic CHAR(1) and then ALTER TABLE x DROP magic will not longer work due to in place alter in 7.2x and above.. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care