Blogs Dennes Torres in Blogs Managing Query Store Hints I wrote about query store hints before when they were first released in Azure SQL databases. However, there are some tricks related to managing query... 02 August 2023 6 min read
Lukas Vileikis Optimizing MySQL: The Basics of Query Optimization In this blog, we will walk you through the basics of query optimization in MySQL. Have a read!… 10 November 2022 4 min read
Aman Sharma Understanding SQL Query Parsing – Part 2: Parent and Child Cursors In the first article of this series, we learned what query parsing is and what impact it has on query performance. In this part of... 12 December 2016 10 min read
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 be poor query design causing... 05 September 2016 14 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 4 In the first three installments of this series I outlined the mechanisms used by Oracle to analyze a very simple query. Sticking with the informal... 09 July 2015 14 min read