This is a list of all articles I’ve written that talk about the mechanisms the optimizer can choose. Each entry has a date stamp and a short note of the contents. The articles are (may eventually) grouped in a couple of different categories, 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.
- Join view delete (May 2022): ANSI expansion problems with deletes from join views
- Adaptive Plans (April 2022): what they can cost and how block then selectively
- Generated predicates (March 2022): virtual columns from “function-based” indexes may allow the optimizer to generate predicates that you weren’t expecting to see
- Hash Aggregation 1 (Jan 2022): you may need to hint hash aggregation for some queries that group by then order by the same columns
- Hash Aggregation 2 (Jan 2022): Workarea operations listed in execution plans may have difference names in the v$sql_workarea.
- use_nl() redux (Oct 2021): where in its processing does Oracle apply join method hints like use_nl()
- A little tweak in 19c (July 2021): the optimizer adding an “is not nulll” predicate that changes the cost of an execution path.
- Join Elimination bug (Mar 2021): inconsistent behaviour when combined with deferrable constraints.
- use_nl_with_index (Mar 2021): a description of what it can do, and one (current) omission
- Index to Simpletalk series on CBO (2015): link to an introductory series of 6 articles on the basics of how the optimizer works that I wrote for Simpletalk.
Other Authors
- Index to Stefan Koehler’s articles on the CBO (2015): a list of articles published on the SAP knowledgebase between 2012 and 2015
[…] Optimizer catalogue […]
Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 2:29 pm GMT Jan 28,2022 |