Re: VACUUM on 2.10

Adam Tauno Williams wrote: >>>Nearest I can tell I am running Informix 2.10.03Y., or at least the > > > Run "onstat" dude! onstat and even tbstat weren't even invented in this era. ;-) >>>core of it is. Looks like it might have been bought and repackaged. >>>None the less, what if any is the SQL to perform a VACUUM on older >>>informix dbs? >> >>what is a VACUUM? > > > "update statistics", this is old Postgres (ingres?) speak. No, you are thinking of ANALYSE. A VACUUM, as detailed already is to remove dead space in the data files. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+