This discussion is archived
3 Replies Latest reply: Mar 19, 2013 1:13 PM by mojave RSS

what is the best book/resource to understand Explain Plan

mojave Newbie
Currently Being Moderated
It is time for me to understand what is going on under the hood. What's the best book out there to understand everything I'm seeing in F10 Explain Plan?
  • 1. Re: what is the best book/resource to understand Explain Plan
    Galo Balda Explorer
    Currently Being Moderated
    Troubleshooting Oracle Performance by Christian Antognini.
  • 2. Re: what is the best book/resource to understand Explain Plan
    rp0428 Guru
    Currently Being Moderated
    Welcome to the forum!
    >
    It is time for me to understand what is going on under the hood. What's the best book out there to understand everything I'm seeing in F10 Explain Plan?
    >
    Why not start with the free information that is available on the web?

    Maria Colgan is a member of Oracle's development team that actually writes the optimizer code. She has written many articles and blogs about how the optimizer works and how to understand explain plans. What better source that one of the people that actually write the code?

    See the white paper titled 'The Oracle Optimizer Explain the Explain Plan'
    http://www.oracle.com/technetwork/database/focus-areas/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf

    Maria references that article on her website at - https://blogs.oracle.com/optimizer/entry/explain_the_explain_plan_white

    And see Maria's article about 'Displaying and reading the execution plans for a SQL statement'
    http://optimizermagic.blogspot.com/2008/02/displaying-and-reading-execution-plans.html

    You can ask questions of the optimizer team on that site and if you search the site you will find many other articles about the optimizer.

    If you search the web for 'oracle 11g explain plan' you will find lots of references. The most important thing is to actually try the examples. You will learn more by doing than just by reading.
  • 3. Re: what is the best book/resource to understand Explain Plan
    mojave Newbie
    Currently Being Moderated
    rp and Galo, thanks again.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points