Oracle Aman Sharma in Oracle 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... 05 September 2016 16 min read
Jonathan Lewis 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... 04 November 2015 14 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 5 It’s been three months since I last published anything in this series on the Cost Based Optimizer, so a thumbnail... 30 October 2015 17 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 2 In the first installment of this series I gave an informal description of how the optimizer would consider the possibilities... 17 June 2015 15 min read