Delete query - performance hit

Database
N/A

Delete query - performance hit

Hi ,

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 

DELETE FROM Table1

WHERE (id ) in ( SELECT id FROM Table2 Where table 2)

Tags (1)
1 REPLY
N/A

Re: Delete query - performance hit

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?