1.OLD:
需求将HH2中的data_object_id同步至HH中。
UPDATE HH A
SET DATA_OBJECT_ID =
(SELECT DATA_OBJECT_ID
FROM HH2 B
WHERE A.object_id = B.object_id)
WHERE EXISTS
(SELECT 1
FROM HH2 B
WHERE A.object_id = B.object_id);
2.优化方向:
使用merge改写,减少HH2的访问次数
MERGE INTO HH A
USING HH2 B
ON (A.object_id = B.object_id)
WHEN MATCHED
THEN
UPDATE SET DATA_OBJECT_ID = b.DATA_OBJECT_ID;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15412087/viewspace-2200008/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15412087/viewspace-2200008/