UPDATE SELECT 操作导致的性能问题
场景描述：UPDATE TABLE_A SET TABLE_A.VALUE =(SELECT TABLE_B.VALUE FROM TABLE_B WHERE TABLE_B.NAME=TABLE_A.NAME);解决方案：MERGE INTO TABLE_A A USING TABLE_B B ON (A.NAME = B.NAME) WHEN MATCHED THEN UPDATE...
