Re: Trun Off Indexes!

From: "Art S. Kagel" <kagel@bloomberg.net> > >Obnoxio The Clown wrote: > >[Snotty message SNIPPED] Whoops! Sorry. Just goes to show, one time I *wasn't* trying to be snotty... :-( > > >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. Anyway, *my* copy of the manual downloaded from the website, from which I now cut and paste, says: [SNIP] Benefits of Disabled Mode The benefits of the disabled mode are as follows: * You can use the disabled mode to insert many rows quickly into a target table. Especially during load operations, updates of the existing indexes and enforcement of referential constraints make up a big part of the total cost of the operation. By disabling the indexes and referential constraints during the load operation, you improve the performance and efficiency of the load. [SNIP] Unless I *really* misunderstand everything, that was what he asked. Anyway, I *am* sorry if I came across as snotty. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com