RE: Massive Delete

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