---In [email protected], <kragh.thomas@...> wrote :
 
 Hey
 I have a database that needs some cleanup, in some tables i need to delete 
millions of rows. I performed the cleanup on a copy of the production database 
in a development environment, using:
 

 delete from table where created < dateadd(-6 month to current_date)
 followed by a count(*) on the table
 

Here you delete some records, but then count whole table.
Add same "where" condition as in "count" query

Regards,
Vlad


Reply via email to