Explain the Explain Plan white paper finally published!

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.


Comments:

Thank you for this very well written whitepaper about analyzing Execution Plans! Will point to it in the Oracle University courses that I deliver :-)

Posted by Uwe Hesse on May 19, 2011 at 05:05 AM PDT #

Hi, Excellent source of information on Explain plan. thanks a lot, baskar.l

Posted by baskar.l on June 01, 2011 at 01:48 PM PDT #

Thanks!

Posted by Maria Colgan on June 02, 2011 at 01:57 AM PDT #

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

Posted by Luis Marques on June 30, 2011 at 11:51 PM PDT #

Thanks , It was very helpful.

Posted by Gunjan on February 13, 2012 at 11:22 PM PST #

Very helpful.
Thanks.

Posted by srikar dasari on May 02, 2013 at 01:55 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

The Oracle Optimizer blog is written by members of the Optimizer development team. The goal of this blog is to provide an insight into the workings of the Optimizer and the statistics it relies on. The views expressed on this blog are our own and do not necessarily reflect the views of Oracle and its affiliates. The views and opinions expressed by visitors on this blog are theirs solely and may not reflect ours.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today