The hypergraph optimizer is now available in MySQL 9.7 Community Edition

I have written a new post on the MySQL blog about the hypergraph optimizer, which is now available in MySQL 9.7 Community Edition. The post gives a high-level technical overview of what is different from the classic join optimizer, why it can produce better plans for some multi-table queries, and...