We have a table with around 900 million records. We want to delete around 95% of rows in this table using a where condition based on date.
When we run DELETE statement it will use REDO and UNDO segments of the database.
How can I run a delete statement by making sure database doesn't use REDO or UNDO of this SQL.
The data is not that critical so we would not have to rollback or redo, that is why we want to run the DELETE
in such a way it will truncate 95% of rows.