Showing entries 1 to 2
Displaying posts with tag: hypergraph optimizer (reset)
MySQL 9.7 Community Edition: Smarter Join Planning with the Hypergraph Optimizer

With the release of MySQL 9.7 Community Edition, the Hypergraph Optimizer is now available to everyone. This is a significant addition to MySQL and one that has generated a lot of excitement in the MySQL community. The promise is simple: better execution plans for complex queries, especially those with many joins. Like most new features, […]

The hypergraph optimizer is now available in MySQL 9.7 Community Edition

MySQL 9.7 Community Edition now includes the hypergraph optimizer as an alternative to the classic join optimizer, making this capability available across all MySQL editions. This is not a cosmetic change. The hypergraph optimizer uses a new join-planning framework aimed at queries where plan shape can make a real difference, particularly for multi-table joins, workloads […]

Showing entries 1 to 2