Oracle Scratchpad

January 28, 2022

Transformations Catalogue

Filed under: Oracle — Jonathan Lewis @ 2:50 pm GMT Jan 28,2022

This is a list of all articles I’ve written about optimizer transformations. Many of these articles will have been listed in the Execution Plans catalogue and Optimizer Catalogue. Each entry has a date stamp and a short note of the contents. The articles are generally listed most-recent first, but there is a separate index to a series I have recently started writing for Simpletalk which lists the articles in the order they were written.

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
  • Ordered hint (Sept 2021) – An accidental example  of two appearances of the “place group by” transformation in a single plan
  • Join Elimination bug (Mar 2021): inconsistent behaviour when combined with deferrable constraints.

A growing list of articles written for Simpletalk (in order of publication)

1 Comment »

  1. […] Transformations catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 3:39 pm GMT Jan 28,2022 | Reply


RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by WordPress.com.

%d bloggers like this: