This is a list of all articles I’ve written discussing execution plans. Each entry has a date stamp and a short note of the contents. The articles are (may be / will be) grouped in a couple of different categories – “long case studies” and “short notes” are a couple of obvious classes – but otherwise are generally listed most-recent first.
I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.
- A case study about looking at the right execution plan in a tkprof output (Dec 2021)
- A case study of a problem arising from adaptive plans and first_rows_N optimisation (Oct 2021)
- If you use bind variable to define ranges in query predicate make sure they are in the right order (Oct 2021)
- Part 1 of a pair of articles examining the qb_registry option of dbms_xplan.display_xxx() (Aug 2021)
- Index to a series of articles on Explain Plan that I wrote for Simpletalk (2014 – 2015)
- Old Plan_table (Jan 2010): why dbms_xplan.display() might have a note: ‘PLAN_TABLE’ is old version
- Predicate Section (Dec 2006): you can’t work out how good the plan is if you don’t report this part of the plan
[…] Execution Plans catalogue […]
Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 3:39 pm GMT Jan 28,2022 |