Aman Sharma Understanding SQL Query Parsing – Part 1 Introduction When it comes to tuning a badly-performing query, there are many things that need to be checked. There may... 05 September 2016 14 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