I’ve a table with 230 million records and from this table I need to delete 300 records everyday on the basis of some condition. Now, this table does not have index created on it. To delete 300 records I’ve created a job which does deletion part. Client is not okay to create index(or partitioned index) on this particular table.

As of now, I’m deleting records from this table using CURSOR FOR method but it is running for 3 hrs to delete 300 records.

Could you please suggest any method to delete the records from huge table which does not have index created on it.