Subject Re: Best way to delete millions of rows
---In, <kragh.thomas@...> wrote :


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