• 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
sql_select.cc 1.02 MB
The source could not be displayed because it is larger than 1 MB. You can load it anyway or download it instead.