Re: Trun Off Indexes!

Posted in 1999

Mark D. Stock — Sun, 30 May 1999 20:10:32 +0200 — source: Informix-list mailing list archive (1991-1998)

Sebastian Paul Avarvarei wrote: > > Me again: > > I want to reconsider my statement a little bit. I think that might be > a situation when disabling/re-enabling the indexes would be faster: > > If the amount of data you load is small compared with the size of the > tables, re-enabling the index would be faster than a full re-index, > and the new data could be indexed better (compared with loading having > the indexes on), since the new data would be processed at the same > time. AFAIK the whole index is built with an ENABLE command. I have not heard of any new features to build partial indexes. > But I'm not very sure about that, so you should wait for the opinions > of the gurus on this. So will I. ;-) 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 |What year 2000 bug? year 2000 bug? |/// / ////| | Fax: +27 838250 2325 |year 2000 bug? year 2000 bug? year |// / /////| |Cell: +27 83 250 2325 |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+