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
[…] https://jonathanlewis.wordpress.com/explain-plan/ […]
Pingback by Explain Plan – Jonathan Lewis | Links to Various sources — April 17, 2020 @ 5:02 am BST Apr 17,2020 |
[…] Index to a series of articles on Explain Plan that I wrote for Simpletalk (2014 – 2015) […]
Pingback by Execution Plans Catalogue | Oracle Scratchpad — February 7, 2022 @ 9:47 am GMT Feb 7,2022 |