db version:10.2.0.3
os :aix 5.3
语句如下:
[php]
Update /*+use_hash(t s)*/ New T
Set T.Date = 20080522
Where T.c_Date = 20080515 And Exists (Select * From Old S Where S.User_Id = T.User_Id)
执行计划走的是两个表做filter,非常慢,两个表过滤的数据量都很大,想改成走hash join.老是不成功
[/php]
os :aix 5.3
语句如下:
[php]
Update /*+use_hash(t s)*/ New T
Set T.Date = 20080522
Where T.c_Date = 20080515 And Exists (Select * From Old S Where S.User_Id = T.User_Id)
执行计划走的是两个表做filter,非常慢,两个表过滤的数据量都很大,想改成走hash join.老是不成功
[/php]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/559870/viewspace-563044/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/559870/viewspace-563044/