Re: Set index disabled/enabled

Gabriel Weisz wrote: > > Can anyone tell me if you are running a > "SET INDEXES FOR TABLE X DISABLE" > and then > "SET INDEXES FOR TABLE X ENABLE" > if there is an index reorg. involved in the process or not. > It seems to me that it is but I am not so sure. The manual > don't explain the process and I will be very grateful if someone > can explain me the process that actually is going on if there is a > reorg or only some flag that disable/enable the usage of the indexes. There is most definitely a reorg. The entire index is basically re-built when you issue the ENABLED command. It is pretty much a flag update when you issue the DISABLED command. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+