summaryrefslogtreecommitdiff
path: root/sql/sql_join_cache.cc
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2022-06-30 14:02:53 +0300
committerMonty <monty@mariadb.org>2022-07-10 15:09:33 +0300
commit0352e855f1be0e440eb9b7dbd8c6b42151252b88 (patch)
treea0074baf04ca2778353dfc57f66b77c06eacb401 /sql/sql_join_cache.cc
parentb34b66a3b2ce1e83428b06d0c2a52b9f2e5b4fe0 (diff)
downloadmariadb-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