Deletion from large table

From: John Dunn <JDunn_at_sefas.com>
Date: Tue, 23 Aug 2016 10:17:25 +0000
Message-ID: <EEC3316514CFB24AB2285394E0D405587C96F5BD_at_BOU.sefasuk.local>

I need to delete large numbers of rows from a large table based upon whether a record exists in a small table.

I am currently using :

            delete from big_table where not exists (select 1 from small_table s where s.id = b.id)"

big_table may have up to 100,000 rows for the same id value. small_table will only have one row per id value

Is there a better way to code this?

John

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 23 2016 - 12:17:25 CEST