• Varun Gupta's avatar
    MDEV-17255: New optimizer defaults and ANALYZE TABLE · 9207a838
    Varun Gupta authored
    Added to new values to the server variable use_stat_tables.
    The values are COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES.
    Both these values don't allow to collect EITS for queries like
        analyze table t1;
    To collect EITS we would need to use the syntax with persistent like
       analyze table t1 persistent for columns (col1,col2...) index (idx1, idx2...) / ALL
    
    Changing the default value from NEVER to PREFERABLY_FOR_QUERIES.
    9207a838
default_mysqld.cnf 4.75 KB