【求助】从大表中删除小表中存在的记录问题
摘要:
A表:30万,主键ID B表:300万,主键ID 从B表中删除ID=A表ID的记录。 DELETE FROM B WHERE EXISTS (SELECT 1 FROM (SELECT ID FROM (SELECT T.ID, ROWNUM RN FROM A) WHERE RN > 0 AND RN 0 AND "RN"<=50000) Statistics ---------------------------------------------------------- 1 recursive calls 0 db block gets 27479 co 阅读全文
浙公网安备 33010602011771号