有两条语句,一条是
Merge into a using (select …… from b where ……) on a.id=b.id
when matched then update ……
when not matched then insert ……
一条是
truncate table a;
insert into a select …… from b where ……;
哪条更优呢?效率更高?
...全文
1202打赏收藏
Merge有什么优点?
有两条语句,一条是 Merge into a using (select …… from b where ……) on a.id=b.id when matched then update …… when not matched then insert …… 一条是 truncate table a; insert into a select …… from b where ……; 哪条更优呢?效率更高?