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.