RE: Runtime for deleteing lots of records

[Jim Damato <jdamato@xxxxxxxxxxxxxxxxx>]

> delete from vroirspl where vlcind>000101 AND VLCIND<020901

Isn't this yymmdd -- January 1, 2000 through September 1, 2002?

-----Original Message-----
From: Booth Martin [mailto:Booth@MartinVT.com]
Sent: Monday, February 10, 2003 11:10 AM
To: midrange-l@midrange.com
Subject: Re: Runtime for deleteing lots of records


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