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';

 

转载于:https://www.cnblogs.com/victor2302/p/6408715.html