loryliu的专栏

r expansion is the use of OR's to process something instead of another method. for example (P and Q are predicates): select * from t where P or Q can be "or expanded" to something like selec

************************************************************* This article is being delivered in Draft form and may contain errors.  Please use the MetaLink "Feedback" button to advise Oracle of an

Optimizer Transformations: OR Expansion By Maria Colgan-Oracle on Apr 11, 2011 We continue our series on Optimizer transformations with OR expansion. I would like to thank Mingxi Wu for the con

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