• Aditya A's avatar
    Bug #23046302 COUNT(*) MUCH SLOWER ON 5.7 THAN 5.6 · 14fe6dd2
    Aditya A authored
    ANALYSIS
    
    This is regression caused due to worklog 6742 which
    implemented ha_innobase::records() which always
    uses clustered index to get the row count. Previously
    optimizer chose secondary index which was smaller in
    size of clustered index to scan for rows and resulted in
    a quicker scan.
    
    FIX
    
    After discussion it was decided to remove this feature in 5.7.
    
    [#rb14040 Approved by Kevin and Oystein ]
    14fe6dd2
ha_innopart.h 31.6 KB