EXPLAIN PLAN FOR SELECT * FROM TABLENAME WHERE 条件; SELECT * FROM TABLE (DBMS_XPLAN.DISPLAY)
以上语句就会运行你想要的执行计划语句,并将执行计划返回,
EXPLAIN PLAN FOR SELECT * FROM TABLENAME WHERE 条件; SELECT * FROM TABLE (DBMS_XPLAN.DISPLAY)
以上语句就会运行你想要的执行计划语句,并将执行计划返回,