• Igor Babaev's avatar
    MDEV-17017 Explain for query using derived table specified with a table · a1fd25c2
    Igor Babaev authored
               value constructor shows wrong number of rows
    
    If the specification of a derived table contained a table value constructor
    then the optimizer incorrectly estimated the number of rows in the derived
    table. This happened because the optimizer did not take into account the
    number of rows in the constructor. The wrong estimate could lead to choosing
    inefficient execution plans.
    a1fd25c2
opt_tvc.test 6.45 KB