Troubleshooting Query Transformations

  • Stelios Charalambides


The Oracle query optimizer is an amazing piece of code, developed and improved over the years (with perhaps a few blind alleys along the way) to generate execution plans that are both easy to generate and that run fast. The optimizer uses a number of “tricks” along the way to improve the speed of execution and implements the execution plan in a way that gives the same results as your unmodified SQL. These “tricks” (or heuristics) sometimes include query transformations.


Nest Loop Execution Plan Query Optimization Original Query Trace File 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Stelios Charalambides 2013

Authors and Affiliations

  • Stelios Charalambides

There are no affiliations available

Personalised recommendations