Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation

Oracle SQL query parsing explained - the query processing workflow from SQL statement to execution plan, the difference between hard...

Basics of the Cost Based Optimizer – part 6

In part 5 of this series I started working through a list of queries designed to demonstrate ways in which...

It’s been three months since I last published anything in this series on the Cost Based Optimizer, so a thumbnail...

In the first installment of this series I gave an informal description of how the optimizer would consider the possibilities...