Re: Deleting Question

Joseph, Drop the indexes, perform the delete and recreate the indexes. Or, perhaps you could move the rows you want to keep into a temp table, drop the table, recreate it and reload from the temp table. If you can do it, it might be quicker. (Depending upon your constraints, you might also need to 'set constraints all deferred'.) --Craig On 7 May 1996 18:44:29 GMT, jkormann@beast.Trenton.EDU (Joseph Kormann) wrote: >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? ====================================================================== Craig Kickel | Unix/C/Database Consultant ckickel@cyberhighway.net | <This space intentionally left blank> ======================================================================