Execution Plans Catalogue

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.

• Case Study (June 2022): an example of the SQL Monitor report showing that a no_merge hint was the appropriate solution
• Case study (Dec 2021): Looking at the right execution plan in tkprok output.
• Case study (Oct 2021):A problem arising from adaptive plans and first_rows_N optimisation.
• 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)
  • Part 2 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
•