Re: Newby help, please - shrinking table size

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? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/