defer updating indexes on inserts

Is there any way to postpone updating indexes when doing a large # of inserts until all of the inserts are done without dropping & recreating the indexes?

Yes, check out index disabling. syntax: set indexes for $TABLE disabled; {load data} set indexes for $TABLE enabled; Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors I'm prepared for all emergencies but totally unprepared for everyday life. ---------- Original Message ----------- From: "JOHN SAYRE" <jsayre@bebe.com> To: ids@iiug.org Sent: Wed, 31 Dec 2008 13:10:00 -0500 (EST) Subject: defer updating indexes on inserts [14414] > Is there any way to postpone updating indexes when doing a large # > of inserts until all of the inserts are done without dropping & > recreating the indexes? > > ***************************************************************************** ** Forum Note: Use "Reply" to post a response in the discussion forum. ------- End of Original Message -------

No. You can DISABLE the index, however, reenabling it will cause the index to be rebuilt from scratch. Art On Wed, Dec 31, 2008 at 1:10 PM, JOHN SAYRE <jsayre@bebe.com> wrote: > Is there any way to postpone updating indexes when doing a large # of > inserts > until all of the inserts are done without dropping & recreating the > indexes? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.