diff options
author | igor@olga.mysql.com <> | 2007-08-02 12:45:56 -0700 |
---|---|---|
committer | igor@olga.mysql.com <> | 2007-08-02 12:45:56 -0700 |
commit | cf39429295846cf944e3fd1a327c554ebd08942d (patch) | |
tree | cb69ff6598e568046e57c591baf10d4a49f2d5b7 /mysql-test/r/events.result | |
parent | 642b0c00ed99334a5540839c0e6598d7a26c8ac7 (diff) | |
download | mariadb-git-cf39429295846cf944e3fd1a327c554ebd08942d.tar.gz |
Fixed bug#28404.
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.
Diffstat (limited to 'mysql-test/r/events.result')
0 files changed, 0 insertions, 0 deletions