![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle hint
文章平均质量分 82
loryliu
这个作者很懒,什么都没留下…
展开
-
OR expansion
r expansion is the use of OR's to process something instead of another method. for example (P and Q are predicates):select * from twhere P or Qcan be "or expanded" to something likeselec转载 2016-08-07 16:52:20 · 347 阅读 · 0 评论 -
How to Switch the Driving Table in a Hash Join (文档 ID 171940.1)
*************************************************************This article is being delivered in Draft form and may containerrors. Please use the MetaLink "Feedback" button to adviseOracle of an转载 2016-10-25 16:54:35 · 315 阅读 · 0 评论 -
Optimizer Transformations: OR Expansion
Optimizer Transformations: OR Expansion By Maria Colgan-Oracle on Apr 11, 2011We continue our series on Optimizer transformations with OR expansion. I would like to thank Mingxi Wu for the con转载 2016-10-02 13:08:43 · 410 阅读 · 0 评论 -
hash join hint
Hash Joins Filed under: CBO,Execution plans,Hints,Oracle,Tuning — Jonathan Lewis @ 12:53 pm GMT Sep 7,2013 I’ve written notes about the different join mechanisms in the past – but such t转载 2016-11-09 13:43:30 · 1388 阅读 · 0 评论