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.