Re: Trun Off Indexes!

Monica If you read OTC's email carefully, you will notice a page number and a manual name. Having that will enable you to get the whole story about disabling indexes which spans some 3-4 pages and consequently would be less "misleading" than a 1-paragraph answer which may or may not solve the immediate problem. And no, I dont work for/with OTC, and nor do I intend to start a flame-war. I am simply pointing out that in this case, the page number and a request to RTFM was more appropriate than an answer. Just my $ 0.02 Sujit Monica <minica@hotmail.com> on 05/28/99 08:25:53 AM Please respond to monica@hotmail.com To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Re: Trun Off Indexes! 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