Re: SQL Delete question -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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  / \

This mailing list archive is Copyright 1997-2024 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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.