Oracle系统优化,两个百万数量的表做关联,用什么提示(hash loop)快一些? ERP,ORACLE,Oracle ERP,MRP,企业管理,甲骨文,Oracle考试,oracle证书,oracle认证...
基于1个网页-相关网页
Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sort merge join, or dynamic hash join.
连接计划指示,强制优化器使用指定的连接方法来连接查询中的表,要么是嵌套循环连接、分类合并连接,要么是动态哈希连接。
I could have used a hash to optimize this loop further, but frankly I don't think it would have made a difference at all unless the user was finding hundreds of thousands of albums.
可以使用一个散列来进一步优化这个循环,但是坦白讲我并不认为这有多重要,除非用户要在无数的唱片中查找。
If TESTING is enabled, the hash entries are printed out in sorted order as the loop executes.
如果TESTING启用,当循环执行时,哈希条目将以排序顺序显示。
应用推荐