Mysql条件的类型决定了是否能走索引

sku表总数据量将近7百万

SELECT count(1) from sku;

已经建立了varchar类型的sku_no的索引

show index from sku;

 

 

EXPLAIN SELECT * FROM sku  WHERE sku_no=77825267;

EXPLAIN SELECT * FROM sku  WHERE sku_no=‘77825267';