MYSQL执行计划

mysql 执行计划

SET optimizer_trace = "enabled=on";

sql 语句

select trace FROM information_scheme.optimizer_trace;

SET optimizer_trace=“enable=off”;

执行完会返回一个json说明如何优化