• Varun Gupta's avatar
    MDEV-19474: Histogram statistics are used even with optimizer_use_condition_selectivity=3 · a461e4d3
    Varun Gupta authored
    The issue here was histogram statistics were being used even when
    the level of optimizer_use_condition_selectivity doesn't allow
    usage of statistics from histogram.
    
    The histogram statistics are read for a table only when
    optimizer_use_condition_selectivity > 3. But the TABLE structure can be
    stored in the internal table cache and be reused for the next query.
    So in this case the histogram statistics will be available for the next query.
    
    The fix would be to make sure to use the histogram statistics only when
    optimizer_use_condition_selectivity > 3.
    a461e4d3
sql_statistics.cc 120 KB