• Varun Gupta's avatar
    MDEV-24353: Adding GROUP BY slows down a query · d79c3f32
    Varun Gupta authored
    A heuristic in best_access_path says that if for an index
    ref access involved key parts which are greater than equal to that
    for range access, then range access should not be considered.
    The assumption made by this heuristic does not hold when
    the range optimizer opted to use the group-by min-max optimization.
    So the fix here would be to not consider the heuristic if
    the range optimizer picked the usage of group-by min-max
    optimization.
    d79c3f32
group_min_max.test 72.4 KB