set use_stat_tables='preferably'; DROP DATABASE IF EXISTS dbt3_s001; CREATE DATABASE dbt3_s001; use dbt3_s001; set optimizer_switch='extended_keys=off'; delete from mysql.index_stats where table_name='lineitem' and index_name in ('i_l_shipdate', 'i_l_partkey'); analyze table lineitem persistent for columns() indexes (i_l_shipdate); delete from mysql.index_stats where table_name='lineitem' and index_name= 'i_l_shipdate'; connect con1, localhost, root,,; connect con2, localhost, root,,; connection con1; use dbt3_s001; set use_stat_tables='preferably'; analyze table lineitem persistent for columns() indexes (i_l_shipdate); connection con2; use dbt3_s001; set use_stat_tables='preferably'; analyze table lineitem persistent for columns() indexes (i_l_partkey); Table Op Msg_type Msg_text dbt3_s001.lineitem analyze status Engine-independent statistics collected dbt3_s001.lineitem analyze status Table is already up to date connection con1; Table Op Msg_type Msg_text dbt3_s001.lineitem analyze status Engine-independent statistics collected dbt3_s001.lineitem analyze status Table is already up to date connection default; disconnect con1; disconnect con2; select * from mysql.index_stats where table_name='lineitem' order by index_name, prefix_arity; db_name table_name index_name prefix_arity avg_frequency dbt3_s001 lineitem i_l_partkey 1 30.0250 dbt3_s001 lineitem i_l_shipdate 1 2.6500 DROP DATABASE dbt3_s001;