执行下面的delete语句非常慢,要一个小时,有没有什么解决办法?DELETE FROM SOCIALINSURANCE@TZ_DBLINK T
WHERE EXISTS (SELECT 1
FROM CHECKBASE CB, CHECKRECORDS CR, CHECKGINSENG CG
WHERE CB.AAA004 = CR.AAA011
AND CB.AAA004 = CG.AAA011
AND CB.AAC003 = T.AAC003
AND CB.AAC002 = T.AAC002)复制代码同样的条件,做select语句大概20秒,为什么delete那么慢?
SELECT t.* FROM SOCIALINSURANCE@TZ_DBLINK T
WHERE EXISTS (SELECT 1
FROM CHECKBASE CB, CHECKRECORDS CR, CHECKGINSENG CG
WHERE CB.AAA004 = CR.AAA011
AND CB.AAA004 = CG.AAA011
AND CB.AAC003 = T.AAC003
AND CB.AAC002 = T.AAC002)复制代码