Dennes Torres in Other 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 1
Other Dennes Torres in Other 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
Oracle Aman Sharma in Oracle Oracle Parent and Child Cursors: The Library Cache Sharing Model, Soft Parse Deep Dive, and Cursor Version Count Diagnostics Oracle parent and child cursors explained - how the library cache shares SQL execution plans across identical statements while maintaining... 12 December 2016 11 min read
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 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