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';
SELECT count(1) from sku;
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