执行以下sql
SET OPTIMIZER_TRACE="enabled=on",END_MARKERS_IN_JSON=on;
SET OPTIMIZER_TRACE_OFFSET=-30, OPTIMIZER_TRACE_LIMIT=30;
-- 为了获取完整的分析结果输出
SET OPTIMIZER_TRACE_MAX_MEM_SIZE=100000000;
${你要执行的SQL}
-- 获取sql追踪分析结果
SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE where QUERY like '%{你执行sql的关键字}%' limit 5;