Re: Trun Off Indexes!

From: Monica <minica@hotmail.com> > >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! You'll notice I gave a specific page number? I don't think it's unreasonable to give an exact, qualified RTFM message, do you? :-) >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 > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com