I want to use the following query to delete around 800M records(we are facing performance issue)
is there any other method to acheive this.Please help
How many rows are in Table1?
What's the PI, is the table Partitioned, Secondary Indexes, etc.?
Can you post the DDL & Explain?
And what's exactly "facing performance issue", Transient Journal, runtime?