• Sergey Petrunya's avatar
    BUG#913030: Optimizer chooses a suboptimal excution plan for Q18 from DBT-3 · 2a16e767
    Sergey Petrunya authored
    - When doing join optimization, pre-sort the tables so that they mimic the execution
      order we've had with 'semijoin=off'. 
    - That way, we will not get regressions when there are two query plans (the old and the
      new) that have indentical costs but different execution times (because of factors that
      the optimizer was not able to take into account).
      
    2a16e767
subselect3.result 55.2 KB