• Sergei Petrunia's avatar
    MDEV-30218: Incorrect optimization for rowid_filtering, correction · 9c6fcdb8
    Sergei Petrunia authored
    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.
    9c6fcdb8
sql_select.cc 955 KB