Bug #120452 Hypergraph Optimizer Improvements

• Submitted: 11 May 18:00
• Reporter: Øystein Grøvlen
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S4 (Feature request)
• Version: 10.x
• OS: Any
• CPU Architecture: Any

[11 May 18:00] Øystein Grøvlen

Description:
Improve the hypergraph optimizer by fixing performance regressions and
continuing to close functional gaps with the old optimizer.

The main focus should be on cases where the hypergraph optimizer
produces less efficient plans than the old optimizer, causing queries
to run slower. These fixes may involve better cardinality estimates,
improved costing, additional access paths, better join ordering, or
support for plan shapes that the hypergraph optimizer does not
currently consider well enough.

Some regressions may also require implementing optimizer functionality
that exists in the old optimizer but is still missing or incomplete in
the hypergraph optimizer. This includes support for additional query
transformations, access methods, plan alternatives, and costing
behavior needed to produce competitive plans across a broader set of
queries.

The goal is to make the hypergraph optimizer more robust and reduce
the number of performance regressions where users need to fall back to
the old optimizer.

How to repeat:
N/A