Insights into Statistics, Query Optimization and the Oracle Optimizer

Explain the Explain Plan white paper published!

Maria Colgan
Distinguished Product Manager

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.

Join the discussion

Comments ( 7 )
  • Uwe Hesse Thursday, May 19, 2011
    Thank you for this very well written whitepaper about analyzing Execution Plans! Will point to it in the Oracle University courses that I deliver :-)
  • baskar.l Wednesday, June 1, 2011
    Excellent source of information on Explain plan.
    thanks a lot,
  • Maria Colgan Thursday, June 2, 2011
  • Luis Marques Friday, July 1, 2011


    Thank you again for this valuable information. Execution Plans are probably the most important feature when analysing performance problems.

  • Gunjan Tuesday, February 14, 2012

    Thanks , It was very helpful.

  • srikar dasari Thursday, May 2, 2013

    Very helpful.


  • guest Thursday, May 5, 2016

    good one

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.