• Monty's avatar
    Adjust costs for rowid filter · 3c1b7fb0
    Monty authored
    - Use log2() insted of log()
    - Added missing ''+' when calculating rowid setup cost
    - Adjusted ROWID_FILTER_PER_ELEMENT_MODIFIER (from 3 to 1)
    
    Other things:
    - Adjusted cost for index_merge where rows_out < 1.0
    
    The effects of the changes:
    - rowid filter will have higher setup cost
    - rowid filter will have slightly less costs per row
    
    This can be seen in mtr where some tests, with 'small tables or
    that uses rowid filters with many rows, will not use rowid filter anymore.
    3c1b7fb0
range_vs_index_merge.result 69.3 KB