Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Keith Simmons — — source: Usenet: comp.databases.informix
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
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.