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

Tag: optimizer

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
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
Oct 2, 2017
Histogram statistics in MySQL
By Erik Frøseth
Oct 25, 2016
MySQL 8.0 Labs: [Recursive] Common Table Expressions in MySQL (CTEs), Part Three - hierarchies
By Guilhem Bichot
Oct 12, 2016
MySQL 8.0 Labs - Descending Indexes in MySQL
By Chaithra Gopalareddy
Sep 14, 2016
MySQL 8.0: Faster batch record retrieval
By Knut Anders Hatlen
Mar 8, 2016
Indexing JSON documents via Virtual Columns
By Matt Lord
Feb 23, 2016
What to do with optimizer hints after an upgrade?
By Manyi Lu
Dec 8, 2015
MySQL 5.7: Improved Performance of Queries with Derived Tables
By Øystein Grøvlen
Oct 28, 2015
Derived Tables in MySQL 5.7
By Roy Lyseng
Jan 7, 2015
When ONLY_FULL_GROUP_BY Won't See the Query Is Deterministic...
By Guilhem Bichot
Dec 15, 2014
Some Notes on Index Statistics in InnoDB
By Vasil Dimov
Dec 10, 2014
MySQL 5.7: only_full_group_by Improved, Recognizing Functional Dependencies, Enabled by Default!
By Guilhem Bichot
Dec 3, 2014
Write Yourself a Query Rewrite Plugin: Part 2
By Martin Hansson


Displaying 1 to 20 of 38 total results
 Search
Categories