mysql优化器使用方式

SET optimizer_trace=“enabled=on”;
需要分析的sql
SELECT * FROM information_schema.OPTIMIZER_TRACE;
SET optimizer_trace=“enabled=off”;