环境:mysql5.6
原SQL: passcode(utf8) applypasscode(utf8mb4) 都添加了索引
SELECT * from bx_employeeinfo e
INNER JOIN bx_order_customer c ON e.passcode = c.applypasscode ;
没有走所以 导致 查询过慢
解决方案 1 修改SQL
例子:convert( 字段 using utf8) COLLATE utf8_general_ci as 字段别名
SELECT * from bx_employeeinfo e
INNER JOIN (SELECT convert(applypasscode using utf8) COLLATE utf8_general_ci as applypasscode FROM bx_order_customer) c ON e.passcode = c.applypasscode ;
走了索引 查询效率高
解决方案 2 修改字符集 统一编码