Re: Rebuilding Indexes and Recovering Space
Posted in 2000
Topics: General Discussion
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/