Re: Trun Off Indexes!

I'm not sure it will actually be too much faster than dropping and recreating the indexes, of course. The index will have to be updated when you re-enable it. Keith Obnoxio The Clown wrote in message <7j2pbf$eue$1@news.xmission.com>... > >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