寻求一些帮助以另一种方式在下面运行delete
,如下所示是长时间运行的。
delete from dbo.customer
where ac_no not in (select ac_no from dbo.account)
也许PostgreSQL可以更好地优化NOT EXISTS
子句:
DELETE FROM dbo.customer
WHERE NOT EXISTS (SELECT 1 FROM dbo.account
WHERE customer.ac_no = account.ac_no);
但是,如果没有看到EXPLAIN
输出,很难说。