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.
[…] Performance catalogue […]
Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 5:30 pm GMT Jan 28,2022 |