Re: Help Deleting Records

In article: <4p1sav$nbt@sjx-ixn4.ix.netcom.com> bedros@ix.netcom.com(Larry E. Bedrosian ) writes: > records from the table. I use the DELETE FROM table WHERE dater < > "03/01/96". This seem to mark the record for deletion, but the table > size is still the same. Is there a pack command that I have to run? > If there is such a command, what is it. > > Please email me at Informix doesnt automatically Squash the data files, if you have a look (at least on some of the later versions of informix) you'll find that the index size often INCREASES due to a "free node list". Informix will use re-use this space as required - but if you want to shrink it in the meantime the two things you can do : 1) unload the data to a file generate a schema for the table (dbschema) drop the table (be careful that you actually HAVE the data) re-create the table load the data back from the file 2) alter one of the main indexes to CLUSTER alter index idxname to cluster I think this regenerates the table then alter index idxname to not cluster should set it back to the way it was Good luck. -- -- Mike Aubury _\\?/_ |O O| +----------oOOO-\\_/-OOOo---------+---------------------------- -+ | Heisenberg may have been here | mike@aubury.demon.co.uk | | | http://www.flash.net/~aubit | +--------------------------------+---------------------------- -+