update /*+ gather_plan_statistics */ wxh_tbd a
set (object_id, object_name) = (select object_id, object_name
from wxh_tbd b
where a.object_id = b.object_id);
set (object_id, object_name) = (select object_id, object_name
from wxh_tbd b
where a.object_id = b.object_id);
试了N种办法，都走不上HASH。
改写如下：
update (
select /*+ BYPASS_UJVC use_hash(a b) ordered */ a.object_name,a.object_id,b.object_name new_object_name,b.object_id new_object_id
from wxh_tbd a, wxh_tbd b
where a.object_id=b.object_id
) set object_name=new_object_name,object_id=new_object_id
;
select /*+ BYPASS_UJVC use_hash(a b) ordered */ a.object_name,a.object_id,b.object_name new_object_name,b.object_id new_object_id
from wxh_tbd a, wxh_tbd b
where a.object_id=b.object_id
) set object_name=new_object_name,object_id=new_object_id
;
如果OBJECT_ID是唯一索引，就不用加BYPASS_UJVC 了
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22034023/viewspace-722640/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
双网卡BOND配置
下一篇：
如何构建高BLEVEL的INDEX？
请登录后发表评论
登录
全部评论
