MySQL Blog Archive
For the latest blogs go to blogs.oracle.com/mysql

Category: OPtimizer

Nov 24, 2023
EXPLAIN INTO and EXPLAIN FOR SCHEMA in MySQL
By Magnus Brevik
Nov 11, 2022
Intersect and Except in MySQL 8.0
By Frederic Descamps
Feb 28, 2020
A must-know about NOT IN in SQL - more antijoin optimization
By Guilhem Bichot
Jan 15, 2020
A new, simple way to figure out why your recursive CTE is running away
By Guilhem Bichot
Dec 18, 2019
Antijoin in MySQL 8
By Guilhem Bichot
Nov 13, 2019
Hash join in MySQL 8
By Erik Frøseth
Oct 17, 2019
MySQL EXPLAIN ANALYZE
By Norvald H. Ryeng
Jul 12, 2019
Supporting all kinds of outer references in derived tables (lateral, or not)
By Guilhem Bichot
Mar 5, 2019
Improvements to ROLLUP in MySQL
By Chaithra Gopalareddy
Feb 21, 2019
JSON specific window functions in MySQL 8.0
By Chaithra Gopalareddy
Jan 31, 2019
Support for LATERAL derived tables added to MySQL 8.0.14
By Guilhem Bichot
Sep 26, 2018
What is the "(scanning)" variant of a loose index scan?
By sreeharsha ramanavarapu
Apr 9, 2018
New Regular Expression Functions in MySQL 8.0
By Martin Hansson
Dec 22, 2017
Row numbering, ranking: how to use LESS user variables in MySQL queries
By Guilhem Bichot
Dec 7, 2017
MySQL 8.0: Query Optimizer Takes Data Buffering into Account
By Øystein Grøvlen
Nov 17, 2017
Optimization to skip index dives with FORCE INDEX.
By sreeharsha ramanavarapu
Nov 11, 2017
New optimizer hint for changing the session system variable.
By Sergey Glukhov
Oct 2, 2017
Histogram statistics in MySQL
By Erik Frøseth
Jul 18, 2017
MySQL 8.0.2: Introducing Window Functions
By Dag Wanvik
May 23, 2017
MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance
By Guilhem Bichot


Displaying 1 to 20 of 56 total results
 Search
Categories