二、optimizer_trace基本使用

#打开optimizer_trace
SET optimizer_trace="enabled=on";
#输入SQL语句
SELECT ...;
#查询optimizer_trace
SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE;
#关闭optimizer_trace
SET optimizer_trace="enabled=off";