Dennes Torres in Blogs T-SQL Tuesday #181: Query Store and its evolution Query Store. This is my choice in relation to “What feature release made you say WOW!”, the subject of this... 09 December 2024 4 min read
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... 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... 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... 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... 09 July 2015 14 min read