Performance catalogue

This is a list of articles that discuss design ideas that can have a big impact on performance. Each entry has a date stamp and a short note of the contents. The articles 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.

On the this blog

• A reprint of a very old article on using materialized views to address performance issues with 3rd party systems (Dec 2021)
• Thoughts on “best practice” – to join, or to use scalar subqueries, or other? (Dec 2021)
• A quick check on what diagnostic statistics are available (Nov 2021)
• Sequence accelerator (Aug 2021): it’s important to think about the sequence cache size for most versions of Oracle, but an enhancement in 21c allows you to forget about it (almost).
• A little tweak in 19c (July 2021): the optimizer adding an “is not nulll” predicate that changes the cost of an execution path.

Other Authors

• An index of articles (dated between 2012 and 2015) about SAP and 12c by Stefan Koehler