Re[2]: Deleting Question
This is a Mime message, which your current mail reader may not understand. Parts of the message will appear as text. To process the remainder, you will need to use a Mime compatible mail reader. Contact your vendor for details. --IMA.Boundary.383295138 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Description: cc:Mail note part For fastest performance, disable the objects (indexes, triggers, and/or constraints), load the data, and re-enable the objects. If you are unsure about the integrity of the data you are loading, set constraints to filtering mode and disable indexes. Filtering mode will cause rows that contain error(s) to be placed in a violation table. When you use: set indexes idx_name disabled; no updates, inserts, or deletes will change the index. The disabled index will not be used in queries. See "Guide to 7.1 Feature Enhancements" pages 3-77 to 3-104 for the set statement and pages 3-109 to 3-129 for the violation table details. The above statements exist from 7.10.UD1 and on. > >bill, > >> If you are running with version 7.x you have the ability to disable >> indexes. However, if you disable an index you allow for for the >> application of index changes when you turn it back on. This is ok >> if you have a period of time when you can delay this processing until. >> >> Check your SQL manual for instructions for disabling/enabling objects. > >i looked briefly in the manual, and couldn't find anything on this. >can you point out where this is? i would like to see this, if there is a >functionality like this, it would make things much easier in many instances, >as in the situation of the original post. > >thanks, > >mickm dboothby@isd.state.in.us Don Boothby (DBA) State of Indiana - ISD Room N551, IGCN 100 N Senate Ave Indianapolis, IN 46204 (317)232-4602 --IMA.Boundary.383295138 Content-Type: text/plain; charset=US-ASCII; name="RFC822 message headers" Content-Transfer-Encoding: 7bit Content-Description: cc:Mail note part >Received: from isd.state.in.us by ima.isd.state.in.us with SMTP > (IMA Internet Exchange 1.04b beta) id 19109b10; Wed, 8 May 96 15:53:05 -0500 >Received: from rmy.rmy.emory.edu ([170.140.97.4]) by mailgate.isd.state.in.us wit >h SMTP id <53765>; Wed, 8 May 1996 15:41:54 -0500 >Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id QAA04084 f >or donald_boothby_at_isdlan@ima.isd.state.in.us; Wed, 8 May 1996 16:48:55 -0400 ( >EDT) >Date:Wed, 8 May 1996 12:55:16 -0500 >From: mickey.mestel@etak.com (Mickey Mestel) >Message-Id: <199605081755.KAA16543@etak.com> >To: informix-list@rmy.emory.edu >Subject: Re: Deleting Question >Sender: informix-list-owner@rmy.emory.edu >Reply-To: mickey.mestel@etak.com (Mickey Mestel) >X-Informix-List-To: donald_boothby_at_isdlan@ima.isd.state.in.us >X-Informix-List-Id: <list.9753> --IMA.Boundary.383295138--