MySQL 8.0: what’s new in Optimizer
There are substantial improvements in optimizer in MySQL 5.7 & MySQL 8.0. Most noticeably, users can now combine relational data with noSQL using the new JSON features. Functional indexes are now supported through generated columns. We also made DBAs’ life easier with explain on a running query and query rewrite plugin. On the performance side, MySQL can avoid creating temporary tables for UNION ALL, enable range scans on IN queries with row value expressions, make use of condition filtering, and more as in 8.0 we have histograms, invisible indexes, common table expressions and we extended the JSON support.
Director Software Development, Oracle
I have 15 years experience in the database field. I am currently working as senior engineering manager at Oracle, heading the MySQL optimizer team. Previously, I held various positions both as product manager and engineering manager at Sun Microsystems.