Re: Trun Off Indexes!

Posted in 1999

Art S. Kagel — Tue, 01 Jun 1999 11:55:21 -0400 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: [Snotty message SNIPPED] > >Obnoxio The Clown wrote: > > > > > From: Sherwin <sherwin@blr.sni.de> > > > > > > > >Can all indexes on a table in an Informix Database be turned off and > > > >then turned on again later. I need to speed up loading of data into my > > > >tables. But I don't wana drop and recreate my indexes, neither do I want > > > >them slowing down my data insertion. > > > > > > Yes you can. Get the SQL Syntax Reference manual at > > > http://www.informix.com/answers and read from page 2-512. Actually Obnoxio that SET INDEXES...DISABLED command does NOT do what Sherwin wanted. The question was can he turn off index updating during a data load so that his inserts are not slowed down. This command just disables UNIQUE index criteria reporting it does not prevent the index from being updated. Art S. Kagel