Re: Runtime for deleteing lots of records

["Booth Martin" <Booth@xxxxxxxxxxxx>]

I am a bit worried about the logic of this statement.  Those numbers look
suspiciously like mmddyy dates.   
 It would seem to me you have just deleted all the records for January and
February (through the 8th) of every year including this year, and kept all
of the records of every year if the day was greater than February 9th. 
Obviously that isn't so as you deleted 8/11 of the file, but I am very very
suspicious of the results of your SQL.
 
 
---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@MartinVT.com
---------------------------------------------------------
 
-------Original Message-------
 
From: Midrange Systems Technical Discussion
Date: Monday, February 10, 2003 04:52:31
To: midrange-l@midrange.com
Subject: Runtime for deleteing lots of records
 
Hi,
 
we had run a job this weekend that deleted lots of old records from a file
with about 22 million records. Some
16 million records were deleted with RUNSQLSTM below:
 
delete from vroirspl where vlcind>000101 AND VLCIND<020901
 
This has run for about 9hours 15min. Is that okay on an 820 with 210GB DASD
(mirrored 6718) and 3GB ram?
It seems to be quite a long time...
 
Regards,
 
Oliver