• Sergei Petrunia's avatar
    MDEV-34720: Poor plan choice for large JOIN with ORDER BY and small LIMIT · 3f65208c
    Sergei Petrunia authored
    Modify the join optimizer to specifically try to produce join orders that
    can short-cut their execution for ORDER BY..LIMIT clause.
    
    The optimization is controlled by @@optimizer_join_limit_pref_ratio.
    Default value 0 means don't construct short-cutting join orders.
    Other value means construct short-cutting join order, and prefer it only
    if it promises speedup of more than #value times.
    
    In Optimizer Trace, look for these names:
    * join_limit_shortcut_is_applicable
    * join_limit_shortcut_optimization
    * limit_shortcut_choice
    3f65208c
order_by_limit_join.test 1.79 KB