Re: Deleting Question

Posted in 1996

Bill Ennis — 8 May 1996 10:03:30 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, 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. -Bill > > We're doing mass-deletes from a table. The problem is it's taking a long > time to run. One reason for this might be that Informix is reindexing > after each delete. Is there a way to turn the automatic reindexing on or > off on the fly? > > > Thanks, > Joseph > jkormann@rfbd.org / jkormann@trenton.edu > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com