• Sergei Petrunia's avatar
    MDEV-20646: 10.3.18 is slower than 10.3.17 · d4edb051
    Sergei Petrunia authored
    Fix incorrect change introduced in the fix for MDEV-20109.
    
    The patch tried to compute a more precise estimate for the record_count
    value in SJ-Materialization-Scan strategy (in
    Sj_materialization_picker::check_qep).  However the new formula is worse
    as it produces extremely optimistic results in common cases where
    SJ-Materialization-Scan should be used)
    
    The old formula produces pessimistic results in cases when Sj-Materialization-
    Scan is unlikely to be a good choice anyway. So, the old behavior is better.
    d4edb051
opt_subselect.cc 204 KB