Can you use HPL to unload the rows you want to keep, drop/recreate the
table and then use HPL to reload only the desired rows?

Of course this won't work if you need the table available 24/7.

If this won't work for you, get Art Kagel's dbdelete from the iiug
software repository, it does a nice job of deleting a large # of rows
quickly without causing long transactions.

Andrew Ford
x32368



-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Tam OShanter
Sent: Tuesday, September 26, 2006 2:15 PM
To: informix-list@iiug.org
Subject: Massive Delete


Hello Again Friends,
Thanks for the help you've provided me so far.

So...
Here are some stats on a table I have:

total record count 20,454,537.00
total record count to be moved to DW and deleted 11,000,921.00

row size of 413 bytes.

How do I go about deleting this data without rendering my server
unusable?

I saw a suggestion of deleting records in 500 record batches, but that
is a
helluva lot of batches to get done what I want.

Any other ideas?

Thanks in advance for the advice.

Tam.


_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list