Re: Rebuilding Indexes and Recovering Space

By my own experience, the only way to recover space (Standard Engine), by reducing the size of the .dat and .idx files is adding a new column to the table and then deleting it. Update Statistics is used to improve the speed of theSELECT clauses (in a few words). --- Joe Maloney <mpir@compuserve.com> escribi': > > > I am new to Informix, having mis-spent (in this > forum's eyes) the last > dozen and more years working with Brand O and Brand > MSS. > > I have been tasked with rebuilding indexes on one of > our databases. I > have spent a significant amount of time looking for > the simple > equivalent of Brand O's 'rebuild index' command or > Brand MSS magic > button. > > In searching this archive, I found several > references to 'set indexes > for table <fred> disable' and '...enable' that > appears to be the > solution I have been looking for (I am not going to > quibble about two > lines versus 1, as long as I don't have to research > the 'create index' > statement.) > > My question is: will using the set disable/enable > pair recover dead > space from the index that may remain from massive > deletes from it's > tables? Or this this automagically handeld by the > special 'Btree > Cleaning Thread' generated by 'Update Statistics'? > or do I need to drop > and recreate the index(es)? > > If you want to email me as well as post, please use > jmaloney@npc.net > for this effort. > -- > Joseph R.P. Maloney, CCP,CSP,CDP > MPiR, Inc. > 502-451-7404 > some witty phrase goes here, I think. > > > Sent via Deja.com http://www.deja.com/ > Before you buy. ===== ______________________________________ Luis Carlos D'az Otero ALCANOS DE COLOMBIA S.A. E.S.P Carrera 9 # 7-25 Neiva (Huila (Colombia)) __________________________________________________ Do You Yahoo!? Send instant messages with Yahoo! Messenger. http://im.yahoo.com/