|
On Tuesday 21 January 2003 5:24 pm, Dennis Munro wrote: [snip] > > Below is the SQL statement used & I am wondering is there something > that would "speed" up the process. . > > <SNIP> > DELETE FROM BPCSF/ESN WHERE SNTYPE = 'P' and SNDESC = > 'Billing date: approx. 4/15/02 March 2002 usage' > Z<SNIP> > > Sure is a simple "program" to accomplish the job but what about > performance? We run 24x7 so letting the SQL statement run some weekend > would impact the least amount of users if that is the only option & I > am not against doing that??? Hi Dennis If the records were written by the one rogue process, is there a chance that the block of records were all consecutive? If so you could delete by rrn which I think woud be quicker. delete from ESN where rrn(esn) > xxxx and rrn(esn) < yyy Regards, Martin -- martin@dbg400.net AIM/Gaim: DBG400dotNet http://www.dbg400.net /"\ DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open \ / Source free test environment tools and others (file/spool/misc) X Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news / \
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.