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
[…] I’ve moved the catalogue of articles I wrote for redgate on reading executions to a static: https://jonathanlewis.wordpress.com/explain-plan/ […]
Pingback by Execution Plans | Oracle Scratchpad — July 19, 2015 @ 10:27 am BST Jul 19,2015 |