Re: Deleting Question

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? Are you sure the problem is just with indexing? What about transaction logging? As others have suggested, you can disable indexes in version 7.whatever or you can drop and recreate indexes in earlier versions. You might also try turning off logging for your database (if it's currently on). This will also avoid a possible long transaction condition. Roger Tomas AG Communication Systems