大家好,我DB2环境遇到一个插入数据的性能问题一张目标表中含有自增长字段 ID INTEGER NOT NULL GENERATED BY DEFAULT target_table当使用insert into target_table(col1,col2) select col1,col2 from source_table插入数据时,执行很慢(10分钟以上)。...(more)
啊,我来晚了用8楼的merge实现会很快merge into busing (select * from a) ion (b.a = i.a and b.b = i.b)when matched then update set b.a = i.a, b.b = i.b,b.xx=i.xx wher...