Explain the Explain Plan white paper finally published!
By Maria Colgan on May 09, 2011
At Oracle Open World last year we delivered a presentation, Explain the Explain plan (session S316955), where we examined the different aspects of an execution plan, from selectivity to parallel execution, and explained what information you should be gleaning from the plan. The long awaited accompanying white paper has finally been released on OTN. The white paper cover the four key topics of an execution plan; cardinality, access methods, join methods, and join order, as well as providing a detailed explanation on of the partitioning and parallel execution sections of an explain plan.