Explain Plan

This is the index to a series of articles I’ve written for redgate, published on their AllThingsOracle site, about generating and interpreting execution plans.

When I started I didn’t really know how many parts it was going to end up as, I had thought maybe 5 or 6 but that was a wildly inaccurate estimate. It has ended up at 14, and I’ve finally finished the last article.

• Part 1 – Finding plans
• Part 2 – Things to see
• part 3 – “The Rule”
• part 4 – Timing and Precision
• part 5 – First Child variations
• Part 6 – Pushed Subqueries
• Part 7 – Query Blocks and View Operators
• Part 8 – Cost, time, etc.  (the predictions)
  
• Part 9 – Multiplication
• Part 10 – Guesswork
• Part 11 – Actuals (Rowsource execution stats)
• Part 12 – Cardinality Feedback
• Part 13 – SQL Trace and tkprof
• Part 14 – SQL Monitor