开启trace并查看
set session optimizer_trace="enabled=on",end_markers_in_json=on;
select * from test1 where name > 'a' ;
SELECT * FROM information_schema.OPTIMIZER_TRACE;
关闭trace
set session optimizer_trace="enabled=off";
开启trace并查看
set session optimizer_trace="enabled=on",end_markers_in_json=on;
select * from test1 where name > 'a' ;
SELECT * FROM information_schema.OPTIMIZER_TRACE;
关闭trace
set session optimizer_trace="enabled=off";