MySQL 5.7, What’s New in the Optimizer - Seguridad Mania.com - España y América Latina

There have been substantial improvements to the optimizer in MySQL 5.7. Most noticeably, users can now combine relational data with NoSQL. MySQL introduced a new JSON datatype & built-in JSON functions, and functional indexes are now supported through both stored and virtually generated columns. 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. In addition to performance improvements, DBAs will enjoy the ability to run EXPLAIN on a running query as well as the new MySQL query rewrite plugin for handling potential performance regressions. Join this webinar to learn how you can leverage these new features!