Re: Trun Off Indexes!

Posted in 1999

Obnoxio The Clown — Fri, 28 May 1999 14:04:32 GMT — source: Informix-list mailing list archive (1991-1998)

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. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

Monica — Fri, 28 May 1999 16:25:53 +0100 — source: Informix-list mailing list archive (1991-1998)

If we had the time to read a whole manual, what makes you think we would be post queries to a news group. Don't be mislead! 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. > > HTH. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com