MySQL中执行计划直接是
explan select * from table;
oracle中需要同时执行
EXPLAIN PLAN FOR
select * from t_bl_dm_ay;
SELECT * FROM TABLE(dbms_xplan.display);
MySQL中执行计划直接是
explan select * from table;
oracle中需要同时执行
EXPLAIN PLAN FOR
select * from t_bl_dm_ay;
SELECT * FROM TABLE(dbms_xplan.display);