Faster/more reliable way to delete millions of rows?

[Alex Duke]

Hello! I'm in the process of working on an independent study project for one of my professors at CSUF, and have been requested to import a huge database dump (>40,000,000 rows of data) and do some work with it. I'm attempting to use a delete where one of the columns doesn't equal zero,

delete from table
where column <> 0;

and it's taking forever, and I've been running into issues and having to restart the query. Is there a better way?

Thanks!