• igor@olga.mysql.com's avatar
    Fixed bug#28404. · cf394292
    igor@olga.mysql.com authored
    This patch adds cost estimation for the queries with ORDER BY / GROUP BY
    and LIMIT. 
    If there was a ref/range access to the table whose rows were required
    to be ordered in the result set the optimizer always employed this access
    though a scan by a different index that was compatible with the required 
    order could be cheaper to produce the first L rows of the result set.
    Now for such queries the optimizer makes a choice between the cheapest
    ref/range accesses not compatible with the given order and index scans
    compatible with it.
    cf394292
distinct.test 18.9 KB