|Subject||Re: Best way to delete millions of rows|
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