Re: Deleting all rows from standard (with loggin) table on IDS 9.40

Lukas Two other alternatives:- 1. At a quiet time turn logging off the database using ontape/onbar, delete your rows then turn ogging back on and take an archive. 2. Program/Script a number of separate deletes by primary key to remove the data in sections. Keith On 21/09/06, Lukas Barton <lukas@cnawr.cz> wrote: > > > Lukas > > > > Quickest and cleanest way is to drop and recreate the table. > > > That's what I don't like to do (I could also drop all foreing keys, > indexes and change table type to raw....delete data... insert new data > ... recreate indexes and foreign keys). > I also have a use case, where I need to delete only aprox 50% of rows > according index (part of primary key). > > Lukas > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >