diff options
| author | Sergei Petrunia <sergey@mariadb.com> | 2023-01-26 12:04:28 +0300 |
|---|---|---|
| committer | Sergei Petrunia <sergey@mariadb.com> | 2023-01-26 16:16:43 +0300 |
| commit | c8f9bb2718c4ed7b464504c54df961bfeb2cccca (patch) | |
| tree | 8351dbedb80f747191e1cf74493eb20a35864d6d /mysql-test/std_data/mysql_upgrade | |
| parent | dd24fa3063e29eb9308eebb3e3471e8fd3fd5ef7 (diff) | |
| download | mariadb-git-c8f9bb2718c4ed7b464504c54df961bfeb2cccca.tar.gz | |
MDEV-30218: Incorrect optimization for rowid_filtering, correction
Enable use of Rowid Filter optimization with eq_ref access.
Use the following assumptions:
- Assume index-only access cost is 50% of non-index-only access cost.
- Take into account that "Eq_ref access cache" reduces the number of
lookups eq_ref access will make.
= This means the number of Rowid Filter checks is reduced also
= Eq_ref access cost is computed using that assumption (see
prev_record_reads() call), so we should use it in all cost '
computations.
Diffstat (limited to 'mysql-test/std_data/mysql_upgrade')
0 files changed, 0 insertions, 0 deletions