diff options
author | Monty <monty@mariadb.org> | 2022-06-30 14:02:53 +0300 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2022-07-10 15:09:33 +0300 |
commit | 0352e855f1be0e440eb9b7dbd8c6b42151252b88 (patch) | |
tree | a0074baf04ca2778353dfc57f66b77c06eacb401 /sql/sql_join_cache.cc | |
parent | b34b66a3b2ce1e83428b06d0c2a52b9f2e5b4fe0 (diff) | |
download | mariadb-git-0352e855f1be0e440eb9b7dbd8c6b42151252b88.tar.gz |
Fix cost calculation in test_if_cheaper_ordering() to be cost based
The original code was mostly rule based and preferred clustered or
covering indexed independent of cost.
There where a few test changes:
- Some test changed from using filesort to index or table scan. This
happened when most of the rows had to be sorted and the ORDER BY could
use covering or a clustered index (innodb_mysql, create_spatial_index).
- Some test changed range to filesort. This where mainly because the range
was scanning most of the rows or using index scan + row lookup and filesort
with table scan is cheaper. (order_by).
- Change in join_cache was because sorting 2 rows is faster than retrieving
10 rows.
- In selectivity_innodb.test one test changed to use a cheaper index.
Diffstat (limited to 'sql/sql_join_cache.cc')
0 files changed, 0 insertions, 0 deletions