Where EXISTS in a delete statement
626362Mar 11 2008 — edited Mar 11 2008Can I use Where EXISTS in a delete statement.
delete from table a
where exists ( select 1
from table b
where a.col1 = b.col1
and ...) ?
Is that more efficient than
delete from table a
where a.col1 in ( select b.col1
from table b
where ......)