• Sergei Golubchik's avatar
    better fix for MySQL bugs · 60c15066
    Sergei Golubchik authored
    BUG#26447 prefer a clustered key for an index scan, as secondary index is always slower
      ... which was fixed to cause
    BUG#35850 queries take 50% longer
      ... and was reverted
    
    and
    
    BUG#39653 prefer a secondary index for an index scan, as clustered key is always slower
      ... which was fixed to cause
    BUG#55656 mysqldump takes six days instead of half an hour
      ... and was amended with a special case workaround
    
    
    sql/opt_range.cc:
      move get_index_only_read_time() into the handler class
    sql/sql_select.cc:
      use cost not an index length when choosing a cheaper index
    60c15066
handler.h 75.5 KB